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 event-driven 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 application-specific 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 (23 P)
Pages in category "VBA"
The following 200 pages are in this category, out of 407 total.
(previous page) (next page)L
M
- Magic squares of odd order
- Make a backup file
- Matrix chain multiplication
- Matrix multiplication
- Matrix transposition
- Matrix-exponentiation 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/Shunting-yard 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
- Pseudo-random numbers/Middle-square 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
- Run-length encoding
S
- Sailors, coconuts and a monkey problem
- Sattolo cycle
- Search a list
- SEDOLs
- Send email
- Sequence of non-squares
- Set
- Set consolidation
- Seven-sided dice from five-sided dice
- Shoelace formula for polygonal area
- Short-circuit 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
- Thue-Morse
- Tic-tac-toe
- 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