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...'
  • 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