Free Microsoft Excel Training Videos

Recording a Macro in Excel



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
Record and use Excel Macros
Recording a macro in Excel 2003

Recording a macro