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 in Excel.
