Page 69 - Microsoft Office Excel 2003 Programming Inside Out

VBA Programming Starter Kit

Caution The value in the Name property of a worksheet or workbook is not necessarily
the same as the name of the same object inside of Excel. Although the two names might
appear to be similar because of default naming rules that the Visual Basic Editor uses, the
names might be different but could be linked together internally to ensure the proper object
is referenced. Object names are more restrictive because they must follow the Visual Basic
for Applications naming rules (no spaces, must begin with a letter, can’t be a reserved
word, and no more than 31 characters in length).

The Code window is the largest window within the Visual Basic Editor and is topped with
two drop-down boxes, as shown in Figure 4-2. The drop-down box on the left, the Object
box, is used to select an object to work on. When working with code only, the box will display
the default General object. The second drop-down box, the Procedure box, is used to select
individual macros within the current module. As macros are added and deleted from the
module, they are also added and deleted from the Procedure box.

Chapter 4

Figure 4-2. The Visual Basic Editor Code Window lets you pick objects and procedures to
work on.

Besides using the Procedure box to select a macro, you can also use the up and down arrow
keys to scroll through the code listings until you reach the macro you want. As you scroll
through each macro, the Procedure box is updated to reflect the macro the insertion point
is in.
The Code window is replaced by the Form Editor when you click Insert, user form, as shown
in Figure 4-3.

For more information about user forms, refer to Chapter 19, “Creating User Forms.”

43
Part 2: Visual Basic for Applications