Microsoft Excel Training Videos

Checking the code of the recorded Macro in MS Excel


In the Visual Basic Editor program provided with Microsoft Excel, you can view the macro code created automatically when you record a macro. You can also edit the macro code to perform another action. For example, instead of multiplying two numbers you could change the Excel macro code by replacing the '*' with a '/' and perform a division through the macro! The Excel training video depicts how easily you can check the macro code in the Visual Basic Editor.
  • Click on Tools
  • Select Macro, Macros...
  • Slect the recorded Macro
  • select 'Edit'
  • Now you can view the code of the recorded Excel macro in the VBA editor





  • Custom Search

    Additional reading on modifying code of a recorded macro in Excel

    How to modify a recorded macro

    How to fix a recorded macro

    Microsoft Excel Training Videos