Page 277 - Excel Progamming Weekend Crash Course

n540629 ch20.qxd 9/2/03 9:35 AM Page 252

252 Saturday Evening

Table 20-1 Continued

Control Function
CommandButton Displays a button that is selected by the user to carry out some action
Frame Used to group other controls, such as OptionButtons
Image* Displays an image

Label Displays text that cannot be edited by the user
ListBox* Displays a list of items from which the user can select
MultiPage* Displays two or more tabs at the edge of the user form, permitting the
user to select from multiple pages on the form
OptionButton Similar to a CheckBox, but only one OptionButton in a group can be
selected at one time. To create a group of OptionButton controls, place
a Frame control on the user form; then draw the OptionButton controls
on the frame.
RefEdit Enables the user to select range in a worksheet

ScrollBar* Displays a vertical or horizontal scroll bar on the user form
SpinButton* Increments and decrements numbers by clicking with the mouse
TabStrip* Performs essentially the same function as a MultiPage but is more flexi-
ble and correspondingly harder to use
TextBox Displays text that the user can edit
ToggleButton A button that can be either up or down, permitting the user to select
and deselect items.

Common Control Properties

While each User Form control has its own set of properties, there are several properties that
are common to all or most controls. Rather than repeating this information for each control,
a compilation of common properties is shown in Table 20-2. Other properties for individual
controls are covered in the following sections.

Table 20-2 Common Properties of User Form Controls

Property Description
BackColor An RGB value specifying the control’s background color
ControlTipText The text that is displayed when the user hovers the mouse cursor
over the control; blank by default.