Executing the procedure from the Macro dialog box

Most of the time, you execute Sub procedures from Excel, not from the VBE. The steps below describe how to execute a macro by using Excel's Macro dialog box.

1. Activate Excel.

Alt+F11 is the express route (of course you can skip this step if Excel is already active).

2. Choose DeveloperOCodeOMacros (or press Alt+F8).

Excel displays the dialog box shown in Figure 5-3.

3. Select the macro.

4. Click Run (or double-click the macro's name in the list box).

Figure 5-3:

The Macro dialog box lists all available Sub procedures.

Figure 5-3:

The Macro dialog box lists all available Sub procedures.

0 0

Post a comment