Category:VBA
This programming language may be used to instruct a computer to perform a task.
Execution method:  Compiled (machine code) 

See Also: 

This page uses content from Wikipedia. The original article was at Visual Basic for Applications. The list of authors can be seen in the page history. As with Rosetta Code, the text of Wikipedia is available under the GNU FDL. (See links for details on variance) 
Visual Basic for Applications (VBA) is an implementation of Microsoft's eventdriven programming language Visual Basic, and associated IDE, which is built into most Microsoft Office applications. It was included in Office applications (apart from version 2008 for Mac OS X), other Microsoft applications such as MapPoint and Visio, and at least partially implemented in some other applications such as AutoCAD, WordPerfect and ArcGIS. It supersedes and expands on the capabilities of earlier applicationspecific macro programming languages such as Word's WordBasic, and can be used to control many aspects of the host application, including manipulating user interface features, such as menus and toolbars, and working with custom user forms or dialog boxes.
As its name suggests, VBA is closely related to Visual Basic and uses the Visual Basic Runtime, but can normally only run code within a host application rather than as a standalone application. It can, however, be used to control one application from another using OLE Automation.
VBA has some important limitations, such as restricted support for function pointers which are used as callback functions in the Windows API. It has the ability to use (but not create) (ActiveX/COM) DLLs, and later versions add support for class modules.
As far was Rosetta Code is concerned, Visual Basic and VBA are mostly interchangeable, with minimal editing necessary to move from one to the other.
Subcategories
This category has the following 3 subcategories, out of 3 total.
@
 VBA examples needing attention (empty)
 VBA Implementations (empty)
 VBA User (21 P)
Pages in category "VBA"
The following 200 pages are in this category, out of 405 total.
(previous page) (next page)2
A
 A+B
 Abbreviations, automatic
 Abbreviations, easy
 Abbreviations, simple
 ABC problem
 Abelian sandpile model
 Abstract type
 Abundant, deficient and perfect number classifications
 Ackermann function
 Address of a variable
 AKS test for primes
 Align columns
 Aliquot sequence classifications
 Almost prime
 Amicable pairs
 Anagrams
 Anagrams/Deranged anagrams
 Angle difference between two bearings
 Anonymous recursion
 Antiprimes
 Apply a callback to an array
 Archimedean spiral
 Arithmeticgeometric mean
 Arithmetic/Complex
 Arithmetic/Integer
 Array concatenation
 Array length
 Arrays
 Assertions
 Associative array/Creation
 Associative array/Iteration
 Associative array/Merging
 Attractive numbers
 Average loop length
 Averages/Arithmetic mean
 Averages/Mean angle
 Averages/Mean time of day
 Averages/Median
 Averages/Mode
 Averages/Pythagorean means
 Averages/Root mean square
 Averages/Simple moving average
B
C
 Caesar cipher
 Call a function
 Call a function in a shared library
 Call an object method
 Casesensitivity of identifiers
 Catalan numbers
 Catamorphism
 Character codes
 Check that file exists
 Chemical calculator
 Cheryl's birthday
 Chinese remainder theorem
 Cholesky decomposition
 Circles of given radius through two points
 Classes
 Closestpair problem
 Collections
 Color of a screen pixel
 Combinations
 Comma quibbling
 Commatizing numbers
 Comments
 Compare a list of strings
 Compound data type
 Concurrent computing
 Conditional structures
 Continued fraction
 Convert decimal number to rational
 Convert seconds to compound duration
 Copy a string
 Count in octal
 Count occurrences of a substring
 Count the coins
 Cramer's rule
 Create a file
 Create a twodimensional array at runtime
 Create an HTML table
 CSV data manipulation
 CSV to HTML translation
 Currency
 CUSIP
D
E
F
 Factorial
 Factors of an integer
 Fast Fourier transform
 Fibonacci nstep number sequences
 Fibonacci sequence
 File input/output
 Filter
 Find limit of recursion
 Find palindromic numbers in both binary and ternary bases
 Finite state machine
 Five weekends
 Fivenum
 FizzBuzz
 Floyd's triangle
 Formatted numeric output
 Fractran
 Function definition
G
H
 Hailstone sequence
 Hamming numbers
 Happy numbers
 Harshad or Niven series
 Haversine formula
 Hello world/Graphical
 Hello world/Standard error
 Hello world/Text
 Heronian triangles
 Higherorder functions
 Hofstadter FigureFigure sequences
 Hofstadter Q sequence
 HofstadterConway $10,000 sequence
 Holidays related to Easter
 Horner's rule for polynomial evaluation
L
 Langton's ant
 Leap year
 Least common multiple
 Leonardo numbers
 Letter frequency
 Levenshtein distance
 Linear congruential generator
 Longest common substring
 Lookandsay sequence
 Loop over multiple arrays simultaneously
 Loops/Break
 Loops/Continue
 Loops/Dowhile
 Loops/Downward for
 Loops/For
 Loops/For with a specified step