Microsoft Office Tutorials and References
In Depth Information
Running a Macro
There are many ways to run a macro; some run automatically when a specified
event occurs, while others require execution.
Running a Macro Automatically
An event in VBA is the same as anywhere else; it’s something that occurs.
Event procedures are procedures that are designed to run when an event
occurs. Events include the opening of an Excel workbook (Workbook_Open), a
change on an Excel worksheet (Worksheet_Change), or the creation of a new
Word document from a template (Document_New). There are other events that
occur on UserForms, such as On_Click of a button.
Most Microsoft Access macros are event procedures.
For a complete list of events in the Microsoft Office Applications, see
Running a Macro Manually
There are also many other macros in this topic, however, that need to be run
either manually or with a keyboard shortcut or toolbar button. Fortunately,
this is very easy to do.
From the main program interface, there are three ways for you to choose which
macro you wish to run:
1. From the menu, choose Tools | Macro | Macros.
2. Click the Run icon
on the Visual Basic toolbar.
3. Press Alt+F8.
Choosing any of the methods above will open the macro dialog box. A copy of
Excel’s macro dialog box is shown on the following page: