Microsoft Office Tutorials and References
In Depth Information
To test how the macro works, you can open the Macro dialog box, click the name of the
macro you want to examine, and then click Step Into. The Visual Basic Editor opens, with
a highlight around the instruction that will be executed next.
To execute an instruction, press F8. The highlight moves to the next instruction, and your
worksheet then changes to reflect the action that resulted from the execution of the
You can run a macro without stopping after each instruction by opening the Macro dialog
box, clicking the macro to run, and then clicking Run. You’ll usually run the macro this way;
after all, the point of using macros is to save time.