Download Microsoft Excel Course Exercise Manual

Excel VBA Introduction – Course Exercise
Terminology used in recording macros
Macro Name

The recorded name for the macro, cannot start with numbers
and have no spaces.
Save a macro as Type

Personal Work Book Stores a local copy of the macro at
application level allowing it to be used with all open work
Books

New Work Book creates a new workbook and captures
whatever you've done in the workbook in which you started
recording. The resulting code is stored in a module in the
"New" workbook.
Could be used in a testing type environment, where you don't
necessarily want to clutter up existing projects.

This Work Book as the name suggests the macro is saved in
the work Book you have open the macro can be only used in
other workbooks if the work Book it was created in is open.

Description This description is places inside the macro as a
comment, these are inside a single quote at the beginning of the
text and are coloured green, comments are used to aid the
developer to identify the code they are using
2