Subscriber only lesson.
Sign up to this course to view this lesson.
About this lesson
Meet the Visual Basic Editor (VBE) - your coding studio.
Download this lesson’s exercise file.Navigating the Visual Basic Editor.xlsm
Navigating the Visual Basic Editor
An introduction to the Visual Basic Editor (VBE) coding studio
When to use
To create or edit macros and other VBA code
Open the Visual Basic Editor via either of the following two methods:
- Go to the Developer tab --> Visual Basic, or
- Press Alt + F11 from Excel
The Visual Basic Editor Windows
The utility windows are all accessible via the VBE's View menu. The most commonly used windows are:
- Project Explorer (shortcut key CTRL + R)
- Properties Window (shortcut key F4)
- Immediate Window (shortcut key CTRL + G)
- Locals Window (no shortcut key)
- Watch Window (no shortcut key)
Opening code panes
- Once you have the Project Explorer showing, simply double click on the object or module you want to work on.
- Note that more than one object or module can be open in the Coding Pane at a time.
To launch a toolbar, go to View --> Toolbars and select the toolbar from the drop-down menu
The toolbars most commonly used are:
Hints & tips
- If a window is closed, open it by clicking on View and selecting the window from the drop-down menu or by using the shortcut key (if available).
- To move a window, left click the window and drag it to the general area you want it to be located until it “snaps” into place.
- To resize a window, hover over the side you want to expand until you see the double arrow. Left click and drag the side over or down until the window is the size you want.
- Each toolbar can be docked in the main toolbar area at the top of the screen. Just click and drag it up until it “snaps” into place.
Lesson notes are only available for subscribers.