Understanding the Project Explorer Window

The Project Explorer window displays a hierarchical list of currently open projects and its elements.

The VBA project can contain the following elements:

■ Worksheets

■ This Workbook—the workbook where the project is stored

■ Classes—special modules that allow you to create your own objects

■ References to other projects

With the Project Explorer you can manage your projects and easily move between projects that are currently loaded into memory.

You can activate the Project Explorer window in one of three ways:

■ From the View menu by selecting Project Explorer

■ From the keyboard by pressing Ctrl+R

■ From the toolbar by clicking the Project Explorer button (see Figure 1-18)

The Project Explorer window contains three buttons.

The first button from the left (View Code) displays the Code window for the selected module. The middle button (View Object) displays the selected sheet in the Microsoft Excel Object folder or a form located in the Forms folder. The first button from the right (Toggle Folders) hides and unhides the display of folders in the Project Explorer window.

Insert User Form

Can! Redo 1

■ak P™Jec! Design Mode 1

Explorer Object Browser 1 Tjoolbox

Ständard

|H il' 0 > ! : p: «

<"- g # ■ M % •

y Ijf 'S 5)

Copy

Find

Undo Typing

| Properties Window Run Project Microsoft Visual

Basic Help Run Sub/UserForm

Resel

Save

Copy

Find

View Microsoft Excel

Undo Typing

| Properties Window Run Project Microsoft Visual

Basic Help Run Sub/UserForm

Resel

Figure 1-18: Buttons on the Standard toolbar provide a quick way to access many Visual Basic features.

0 0

Post a comment