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)L
M
 Magic squares of odd order
 Make a backup file
 Matrix chain multiplication
 Matrix multiplication
 Matrix transposition
 Matrixexponentiation operator
 Middle three digits
 Minesweeper game
 Modular arithmetic
 Modular inverse
 Morse code
 Multiplication tables
 Munchausen numbers
 Musical scale
 Mutual recursion
N
P
 Palindrome dates
 Palindrome detection
 Pangram checker
 Parsing/RPN calculator algorithm
 Parsing/Shuntingyard algorithm
 Pascal matrix generation
 Pascal's triangle
 Password generator
 Peano curve
 Penney's game
 Pentagram
 Perfect numbers
 Perfect shuffle
 Permutations
 Pernicious numbers
 Phrase reversals
 Pick random element
 Pig the dice game
 Play recorded sounds
 Playfair cipher
 Plot coordinate pairs
 Pointers and references
 Polynomial long division
 Polynomial regression
 Population count
 Power set
 Price fraction
 Primality by trial division
 Prime conspiracy
 Priority queue
 Problem of Apollonius
 Program name
 Program termination
 Proper divisors
 Pseudorandom numbers/Middlesquare method
 Pythagorean quadruples
 Pythagorean triples
R
 Range expansion
 Range extraction
 Read a file line by line
 Reduced row echelon form
 Remove duplicate elements
 Remove lines from a file
 Repeat
 Repeat a string
 Return multiple values
 Reverse a string
 Reverse words in a string
 Roman numerals/Decode
 Roman numerals/Encode
 Roots of unity
 Runlength encoding
S
 Sailors, coconuts and a monkey problem
 Sattolo cycle
 Search a list
 SEDOLs
 Send email
 Sequence of nonsquares
 Set
 Set consolidation
 Sevensided dice from fivesided dice
 Shoelace formula for polygonal area
 Shortcircuit evaluation
 Show ASCII table
 Sierpinski carpet
 Sierpinski pentagon
 Sierpinski triangle
 Sieve of Eratosthenes
 Sleep
 Solve hanging lantern problem
 Sort numbers lexicographically
 Sorting algorithms/Bead sort
 Sorting algorithms/Bogosort
 Sorting algorithms/Bubble sort
 Sorting algorithms/Cocktail sort
 Sorting algorithms/Cocktail sort with shifting bounds
 Sorting algorithms/Comb sort
 Sorting algorithms/Counting sort
 Sorting algorithms/Gnome sort
 Sorting algorithms/Heapsort
 Sorting algorithms/Insertion sort
 Sorting algorithms/Pancake sort
 Sorting algorithms/Quicksort
 Sorting algorithms/Selection sort
 Special variables
 Spelling of ordinal numbers
 Spiral matrix
 Split a character string based on change of character
 Stable marriage problem
 Stack
 Stack traces
 Statistics/Basic
 Statistics/Normal distribution
 String append
 String case
 String concatenation
 String interpolation (included)
 String length
 String matching
 String prepend
 Strip a set of characters from a string
 Strip block comments
 Strip whitespace from a string/Top and tail
 Substring
 Sudoku
 Suffixation of decimal numbers
 Sum and product of an array
 Sum multiples of 3 and 5
 Sum of a series
 Sum of squares
 System time
T
 Taxicab numbers
 Temperature conversion
 Test a function
 Text between
 The Name Game
 The Twelve Days of Christmas
 ThueMorse
 Tictactoe
 Time a function
 Tokenize a string
 Tokenize a string with escaping
 Top rank per group
 Topic variable
 Total circles area
 Totient function
 Tree traversal
 Trigonometric functions
 Twelve statements
 Two sum
 Type detection