Excel VBA - Visual Basic Editor in Excel 2010 / 2007

To launch the Visual Basic Editor in Excel 2010 or Excel 2007, click on Visual Basic (or press Alt+F11).

The Visual Basic Editor appears:

The left window with the sheet names in it is called the Project Explorer. If you can't see the Project Explorer, click on View and then Project Explorer. Most probably the Project Explorer will already appear as a column on the left side of the screen. If not, execute the following three steps to achieve this.

1. Right click on the Project Explorer.
2. Check Dockable (if necessary).
3. Click on Project - VBAProject and drag the Project Explorer to the left side of the screen.

The Code window can be added by clicking on one of the sheet names. To cover the whole screen, you can maximize the Code Window. We think this is the best configuration of the Visual Basic Editor.