Microsoft Office Tutorials and References
In Depth Information
Record a Macro
You can save time and make the process of
creating a macro easier by recording some or
all of the actions you want your macro to
VBA is a powerful language that can perform a
wide variety of tasks, but its main purpose is to
operate on the application in which it is
running. With Excel VBA, for example, you
can create macros that add text and formulas
to cells, format ranges, insert or delete
worksheets, and much more.
To build a macro that manipulates Excel in
some way, VBA gives you a method that is
faster and easier than writing the macro
yourself: the macro recorder. After you activate
this tool, you use Excel to perform the action
or actions that you want in the macro. All the
text or formulas you insert in cells, all the
formatting you apply, and all the commands
and buttons that you click, are recorded,
translated into the equivalent VBA statements,
and then stored as a macro for later use.
You can store your recorded macros in
any workbook, but Excel provides a special
workbook for this purpose: the Personal
1 Click the View tab.
2 Click the Macros
3 Click Record Macro.
● If you have the Developer
tab displayed, you can
also click the Macro
Recording icon in the
The Record Macro dialog
4 Type a name for the
5 Click the Store Macro In
drop-down arrow to
select the name of the
workbook you want to
use to store the macro.
Note: For most macros, it is best to
store the code in the Excel Personal
6 (Optional) Type a
description of the macro.
7 Click OK.
Excel starts the macro