Excel 2010 Bible

Chapter 41: Creating UserForms

845

To display the Properties window, choose View ➪ Properties Window (or press F4). The

Properties window displays a list of properties for the selected control. (Each control has a differ-

ent set of properties.) If you click the UserForm itself, the Properties window displays properties

for the form. Figure 41.7 shows the Properties window for a CommandButton control.

To change a property, select the property in the Properties window and then enter a new value.

Some properties (such as BackColor) enable you to select a property from a list. The top of the

Properties window contains a drop-down list that enables you to select a control to work with. You

can also click a control to select it and display its properties.

FIGURE 41.7

The Properties window for a CommandButton control.

When you set properties via the Properties window, you’re setting properties at design time. You

can also use VBA to change the properties of controls while the UserForm is displayed (that is, at

run time).

A complete discussion of all the properties is well beyond the scope of this book — and it would

indeed be very dull reading. To find out about a particular property, select it in the Properties win-

dow and press F1. The Help for UserForm controls is extremely thorough.