Visual Basic Editor Setup

Parallel Project Download

Using the following link, you may download an Excel workbook that is complete up to this point in the project. At key times during the project, similar download opportunities will be provided. This allows you to start "on the same page" if you wish.

This feature becomes more important later in the project when we write a lot of VBA code. For example, you may have a bug in your VBA that you can't find. Having access to a workbook that has the correct VBA code allows you to find the bug or just continue with the project using the downloaded workbook. At the end of the project, we provide a link so that you can download the complete Trip Planner project.

Download Trip_Planner_Dload01.xls

VB Editor Toolbars

Open your workbook saved from the previous lesson or the downloaded workbook.
Use Alt + F11 to go to the VB Editor. Alternatively, you can add a VB Editor button to one of your toolbars using the instructions provided in the Main Course (Opening the VB Editor).
If you have not done so already, add the Debug and Edit toolbars to the VB Editor using View > Toolbars > Debug and View > Toolbars > Edit. (Toolbars in the VB Editor)

Set Option Explicit

For this project, we are going to turn on VB Editor Option Explicit. This will force variable declaration and help with code debugging (see Option Explicit: Requiring Variable Declaration).

In the VB Editor, do a menu command Tools > Options. This brings up the Options dialog.
Put a check by Require Variable Declaration. This will cause the Option Explicit key words to be added to the declarations section of every new code module that you add to the project.

Click OK.

VBATrain Home | Samples TOC | Previous | Next