Macro
What is a macro?
a series of commands, actions, and functions that can be stored and initiated (run) whenever you want to perform a particular task
3 ways to create macros
use the macro recorder to record a new macro
write a new macro from scratch in visual basic editor
copy, paste, or edit a previously created macro
Local Window
displays variables and how they change as a macro is run. It is useful in debugging (correcting errors in) a macro. The Local Window can be accessed under the View menu in Visual Basic Editor.
Property
an attribute of an object in Excel that defines/changes one of its characteristics (such as its name, size, color, formula, value, or location). All objects have properties
what is visual basic for application?
programming language used to create macros in excel
Window in visual basic editor that displays visual basic code commands for a macro
Method
an action that can be performed on an object (such as clear contents, copy, delete, select, save, close, etc.).
Syntax
the set of rules specifying how you must enter Visual Basic commands
What is visual basic editor?
All macros created in excel are stored in visual basic editor. you can create new ones or edit old ones too on here.
Help clarify the purpose and meaning of a macro
Modules
a collection of macros located in the Visual Basic Editor
Variable
a named storage location in Visual Basic Editor that contains data you can retrieve and modify while the macro code is being executed
Visual Basic commands
steps that define the macros functionality
F1 Function
will retrieve help when pressed while an object, property, or method of Visual Basic code is highlighted in the Visual Basic Editor
Object
is an element of the Excel Application (such as a worksheet, a cell, a range of cells, or the entire workbook). Macro code is written to manipulate an
object by performing an action on that object (through a method) or changing a characteristic of an object (through a property).
automate repetitive excel tasks
automate and control input
guide users through a spreadsheet
microsoft visual basic help
separate from the normal Excel Help feature. You must be in Visual Basic Editor to access this help.Click on Help while in Visual Basic Editor. Click on the Visual Basic for Applications Language Reference link to access various help topics related to using Visual Basic
Project Explorer window
is located on the left side of the Visual Basic
Editor. In this window, you can access macros you have recorded or written in modules or ThisWorkbook.