Accountancy 2258
Exam 3 Study Guide
1. Macros
a. Be familiar with ALL terminology defined in the Macro Review Materials.doc
file.
Macro: a series of commands, actions, and functions that can be stored and initiated
...
Accountancy 2258
Exam 3 Study Guide
1. Macros
a. Be familiar with ALL terminology defined in the Macro Review Materials.doc
file.
Macro: a series of commands, actions, and functions that can be stored and initiated (run)
whenever you want to perform a particular task.
Visual Basic for Applications(VBA): refers to a programming language you can use to
create macros.
Visual Basic Editor (VBE): embedded within Excel and can be accessed through the
Developer tab.
Visual Basic Commands: are the steps of the macro that define the macro’s functionality.
“Macro Code”
Code Window: the window in the Visual Basic Editor (VBE) that displays the Visual
Basic code (commands) for a macro.
Comments: documentation located in the Visual Basic code to help clarify the purpose
and meaning of a macro.
Local Window: displays variables and how they change as a macro is run
Method: action that can be performed on an object (such as clearcontents, copy, delete,
select, save, close, etc.)
Module: a collection of macros located in the Visual Basic Editor. You can place several
macros in one module or create new modules for each individual macro.
Object: an element of the Excel Application (such as a worksheet, cell, range of cells, or
entire workbook).
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).
Syntax: the set of rules specifying how you must enter Visual Basic commands.
Variable: a named storage location in Visual Basic Editor that contains data you can
retrieve and modify while the macro code is being executed.
b. Understand how to use Active X Controls – combo box, spin button, scroll bar,
option buttons, and check boxes – and know why/when each of these would be used.
c. Know the major components of the Visual Basic Editor and what each is used for
– Project Explorer window, Code window, comments (in green), VBA instructions/code,
Modules, and ThisWorkbook.
d. VBA macros (procedures) – what they are and why they are used
[Show More]
