Page 47 - Excel Progamming Weekend Crash Course

d540629 ch02.qxd 9/2/03 9:27 AM Page 22

22 Friday Evening

Procedure view. A single procedure displays at a time; when the cursor is at the end
or beginning of the displayed procedure, press PgDn or PgUp to view the previous or
next procedure.

To toggle between these two modes, use the Full Module View and Procedure View but-
tons at the bottom of the editing window (see Figure 2-4).

Full module view
Procedure view
Figure 2-4 Switching between Full Module View and Procedure View

Use the drop-down list at the top right of the editing window to immediately
view any procedure in the module.
Tip

The Property Window

The Property Window is located by default in the lower left corner of the VBA Editor screen.
This window displays the properties of the object that is current, or active, in the Editor.
A property is an attribute of an object that controls some aspect of the object’s appearance
or behavior. For example, a Worksheet object has a Name property that specifies the work-
sheet’s name and also (among many others) a Visible property that determines whether
the worksheet is visible onscreen. Some objects have very few properties. A module, for
example, has only the Name property. Figure 2-5 shows the Property Window when a work-
sheet is selected in the Project Explorer.