Microsoft Office Tutorials and References
In Depth Information
Adjusting UserForm Controls
Using the Properties window
In the VBE, the Properties window adjusts to display the properties of the selected item (which
can be a control or the UserForm itself). In addition, you can select a control from the drop-down
list at the top of the Properties window. Figure 13-6 shows the Properties window for an
Figure 13-6: The Properties window for an OptionButton control.
The Properties window has two tabs. The Alphabetic tab displays the properties for the
selected object in alphabetical order. The Categorized tab displays them grouped into
logical categories. Both tabs contain the same properties but in a different order.
To change a property, just click it and specify the new property. Some properties can take on a finite
number of values, selectable from a list. If so, the Properties window will display a button with a
downward-pointing arrow when that property is selected. Click the button, and you’ll be able to select
the property’s value from the list. For example, the TextAlign property can have any of the
following values: 1 - fmTextAlignLeft , 2 - fmTextAlignCenter , or 3 - fmTextAlignRight .
A few properties (for example, Font and Picture ) display a small button with an ellipsis when
selected. Click the button to display a dialog box associated with the property.