Microsoft Office Tutorials and References
In Depth Information
The ListBox control presents a list of items, and the user can select an item (or multiple items).
ListBox controls are very flexible. For example, you can specify a worksheet range that holds
the ListBox items, and this range can consist of multiple columns. Or you can fill the ListBox with
items by using VBA.
A MultiPage control lets you create tabbed dialog boxes, like the Format Cells dialog box. By
default, a MultiPage control has two pages, but you can add any number of additional pages.
OptionButton controls are useful when the user needs to select one item from a small number
of choices. OptionButtons are always used in groups of at least two. When one OptionButton is
selected, the other OptionButtons in its group are deselected.
If your UserForm contains more than one set of OptionButtons, the OptionButtons in each set
must share a unique GroupName property value. Otherwise, all OptionButtons become part of
the same set. Alternatively, you can enclose the OptionButtons in a Frame control, which
automatically groups the OptionButtons contained in the frame.
The RefEdit control is used when you need to let the user select a range in a worksheet. This
control accepts a typed range address or a range address generated by pointing to the range in a
The ScrollBar control is similar to a SpinButton control. The difference is that the user can
drag the ScrollBar button to change the control’s value in larger increments. The ScrollBar
control is most useful for selecting a value that extends across a wide range of possible values.
The SpinButton control lets the user select a value by clicking either of two arrows: one to
increase the value and the other to decrease the value. A SpinButton is often used in conjunction
with a TextBox control or Label control, which displays the current value of the SpinButton. A
SpinButton can be oriented horizontally or vertically.