Excel VBA 1.1

Opening the Visual Basic Editor (VBE)

Step 1: Open a Workbook

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.

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

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):

Be the first to comment

Leave a Reply