Once your VBA code for a given project is complete, you may find yourself
working mainly with your Excel worksheet to change variables or adjust the
model. There are several options for executing the VBA code from within
your worksheet. Three of them are described here.
First, you can simply run the macro using the built-in menu structure or
shortcut keys. In any recent version of Excel, the key combination Alt+F8
will open the Macro dialogue.
Alternatively, in Excel 2003, you can select "Tools - Macro - Macros..." from
the drop-down menu:
And in Excel 2007 you can select "Macros" from the Developer tab in the Ribbon:
In either version of Excel, the above actions will open the Macro dialogue.
Select the desired macro (VBA function), and press "Run."