Recording Macros

Recording a Macro in Excel 2003

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.

Further reading:

Record and use Excel macros

Recording Macros – Excel 2003

One thought on “Recording Macros

Leave a Reply

Your email address will not be published. Required fields are marked *