If you plan on typing the macro without using the macro recorder
, you can choose Insert, Module from the VBA menu.
Finally, to create the macros for the three buttons on the Main Menu, select the Main menu tab and turn on the macro recorder
. Under Macro name:, type goto_cust_form and hit OK.
Remember that the macro recorder
is still operating, indicated by the Stop Recording toolbar floating over your workbook.
The overall trick for creating macros is to properly assemble the code from the Macro Recorder
and other sources in a program and apply it to the situation rather than writing code from scratch.
In addition to a group of new macro commands, version 3.0 also contains a macro recorder
and a macro library file.
While the macro recorder
is running, access the Page Setup dialog.
You might have experimented using the macro recorder