Tuesday, September 25, 2012

Excel VBA - Visual Basic Editor in Excel 2003


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

Launch the Visiual Basic Editor in Excel 2003

The Visual Basic Editor appears:

The Visual Basic Editor in Excel 2003

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.

No comments:

Post a Comment