excel-vba Opening the Visual Basic Editor (VBE)


Example


Step 1: Open a Workbook

enter image description here


Step 2 Option A: Press Alt + F11

This is the standard shortcut to open the VBE.

Step 2 Option B: Developer Tab --> View Code

First, the Developer Tab must be added to the ribbon. Go to File -> Options -> Customize Ribbon, then check the box for developer.

enter image description here

Then, go to the developer tab and click "View Code" or "Visual Basic"

enter image description here

Step 2 Option C: View tab > Macros > Click Edit button to open an Existing Macro

All three of these options will open the Visual Basic Editor (VBE):

enter image description here