Excel Effects

Reference guide.

View code from a macro in Excel – Quick tip

View code from a macro in Excel - Quick tip

At times, you will want to view code from a macro in Excel. Basically, viewing macro code allows you to see the instructions Excel used to perform your tasks.

In addition, it allows you to make changes to the code, like adding or removing code. So keep in mind, you need some sort of coding experience, preferably with Visual Basic.


For the purpose of this lesson, we suggest you use Excel 2007 or higher or compatible to conduct steps in this task.


Steps to view code from macro code in Excel

Follow the steps below to view macro code in Excel.

Steps 1 and 2 - Show macro dialog box

  1. From the main menu, click Developer.
  2. Under the Code group, select Macros.

After clicking Macros, the Macro dialog box will appear. Shortcut alert: Pressing Alt+F8 will bring up the Macro dialog box also.


Steps 3 and 4 - Macro dialog box

  1. Select your macro from the macro list.
  2. Press Step Into.

When you press Step Into, the Visual Basic for Applications (VBA) editor opens.


Note: If you do not have any macros to view, then you can create one from our Record a basic macro in Excel lesson. Otherwise, feel free to follow along through the steps.


Success!

Success! The Visual Basic for Applications window is now open

Finally, there it is! From here, you can do almost anything.


Additional resources


View code from a macro in Excel - Quick tip
by Excel Effects :: October 24, 2020


Home

Techronology

Artplotty Grid

Development Category (English)300x250

Microsoft Surface Book 3