After recording a macro in Excel you can study
the VBA code and run the macro in another sheet to see the results. The
following describes the process of recording an Excel macro. The
recording is also shown in the training video:
- Click on Tools
- Go to Macro
- Select 'Record New Macro...'
- A new 'Record Macro' window opens
- Accept the name Macro1 and other parameters as is. As you
would have observed you can assign a shortcut key to run the macro
- Click on OK
- Do your calculations or work as usual
- After completing your work, select Tools from menu bar,
Macro, Stop Recording
In the next session we'll see
how to check the code of the recorded Excel macro.
Links to recording a macro
|