The Project Explorer

The Project Explorer is an essential navigation tool. In VBA, each workbook contains a project. The Project Explorer displays all the open projects and the component parts of those projects, as you can see in Figure 1-6.

You can use the Project Explorer to locate and activate the code modules in your project. You can doubleclick a module icon to open and activate that module. You can also insert and remove code modules in the Project Explorer. Right-click anywhere in the Project Explorer window, and from the context menu select Insert to add a new standard module, class module, or UserForm.

To remove Module1, right-click it and choose Remove Module1. Note that you can't do this with the modules associated with workbook or worksheet objects. You can also export the code in a module to a separate text file, or import code from a text file.

Figure 1-6

0 0

Post a comment