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

See Also: 

If you know VBA, please write code for some of the tasks not implemented in VBA.
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.
Pages in category "VBA"
The following 375 pages are in this category, out of 375 total.
2
A
 A+B
 Abbreviations, automatic
 Abbreviations, easy
 Abbreviations, simple
 ABC Problem
 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
 Angle difference between two bearings
 Anonymous recursion
 Antiprimes
 Apply a callback to an array
 Archimedean spiral
 Arithmeticgeometric mean
 Arithmetic/Integer
 Array concatenation
 Array length
 Arrays
 Assertions
 Associative array/Creation
 Associative array/Iteration
 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
 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 seconds to compound duration
 Copy a string
 Count in octal
 Count occurrences of a substring
 Count the coins
 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
 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
 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
 Lookandsay sequence
 Loops/Break
 Loops/Continue
 Loops/Dowhile
 Loops/Downward for
 Loops/For
 Loops/For with a specified step
 Loops/Foreach
 Loops/Increment loop index within loop body
 Loops/N plus one half
 Loops/Nested
 Loops/While
 Loops/with multiple ranges
 Loops/Wrong ranges
 LU decomposition
 Luhn test of credit card numbers
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 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
 Power set
 Price fraction
 Primality by trial division
 Prime conspiracy
 Priority queue
 Problem of Apollonius
 Program name
 Program termination
 Proper divisors
 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
 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
 Sort numbers lexicographically
 Sorting algorithms/Bead sort
 Sorting algorithms/Bogosort
 Sorting algorithms/Bubble sort
 Sorting algorithms/Cocktail sort
 Sorting algorithms/Comb sort
 Sorting algorithms/Heapsort
 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
 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