Excel 2010 Bible

Chapter 42: Using UserForm Controls in a Worksheet

863

The manner in which you change a property depends upon the property. Some properties display

a drop-down list from which you can select from a list of options. Others (such as Font) provide a

button that when clicked, displays a dialog box. Other properties require you to type the property

value. When you change a property, the change takes effect immediately.

Tip
To find out about a particular property, select the property in the Properties window and press F1. n

The Properties window has two tabs. The Alphabetic tab displays the properties in alphabetical

order. The Categorized tab displays the properties by category. Both tabs show the same proper-

ties; only the order is different.

FIGURE 42.3

Use the Properties window to adjust the properties of a control — in this case, a CommandButton control.

Common properties

Each control has its own unique set of properties. However, many controls share properties. This sec-

tion describes some properties that are common to all or many controls, as set forth in Table 42.2.

Note
Some ActiveX control properties are required (for example, the Name property). In other words, you can’t
leave the property empty. If a required property is missing, Excel will always tell you by displaying an error
message. n