Macro & VBA Flashcards
A set of instructions that execute a sequence of commands to automate repetitive or routine tasks
Macro
What’s used to create a macro (2)
Macro recorder
Visual Basic for Application (VBA)
Where can you find Macro
View tab
Developer Tab
A robust programming language that can be used in various software packages to enhance and automate functionality
VBA
A file in which macros are stored
Module
An application used to create, edit, execute and debug macros using programming language
Visual Basic Editor (alt + F11)
A procedure or macro always begin and end with the
Sub and End Sub statements
These are in green and provide information about the macro but do not affect its execution
Comments
These are in blue and they are special syntax that have special meaning
Keywords
Two types of VBA macros
Sub procedures
Custom functions
Perform actions on a workbook, like clear form or insert current date in a worksheet; created when using the macro recorder
Sub procedures
Similar to other built-in functions in Excel; manipulate input variables and return a value
Custom functions
A container for text
Label
Allows the user to type text
TextBox
A drop down list
ComboBox