Visual Basic Editor

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.

Did you find this information helpful? Show your appreciation, vote for us.

Go to Top: Visual Basic Editor    |    Go to Next Topic: Macro Comments

To launch the Visual Basic Editor in Excel 2003, click on View Code from the Control Toolbox (or press Alt+F11).

The Visual Basic Editor appears:

The window on the left with the names Sheet1, Sheet2 and Sheet3 in it is called the Project Explorer. If you can't see the Project Explorer, you can 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 white part of the Project Explorer.

2. Check Dockable (if not already done so).

3. Click on Project - VBAProject and drag it to the left until your cursor (white arrow) touches the middle of the left side of the screen.

To add the Code window, simply click on one of the sheets. Maximize the Code window so it will cover the whole screen. Once this has been completed, the configuration should be consistent with the picture above. We think this is the best configuration of the Visual Basic Editor.

Did you find this information helpful? Show your appreciation, vote for us.

Go to Top: Visual Basic Editor    |    Go to Next Topic: Macro Comments