Page 209 - Excel Data Analysis

11 537547 Ch10.qxd 3/4/03 12:03 PM Page 195

FORM CONTROLS 10

THE FORMS TOOLBAR

he Forms toolbar contains the controls that you can the user clicks the control. See the section "Add a Form
add to a worksheet to display specific data values, Control to a Worksheet" for more information on using
T perform certain actions, or capture user input. You controls on a worksheet.
can attach a macro to a form control that executes when

LABEL BUTTON OPTION BUTTON
Provides information Runs the associated Selects one of a group
about an associated macro when clicked. of options.
control or worksheet.

GROUP BOX CHECK BOX LIST BOX
Places related controls Selects or deselects Displays a list of
together visually on a an option. items for selection.
worksheet.

SCROLL BAR CONTROL PROPERTIES COMBO BOX
Increases or decreases Displays the Format A menu that displays a
a value when users Control dialog box. list of items. The selected
click the arrow item appears in the
text box.
SPINNER EDIT CODE TOGGLE GRID
Scrolls up and down Displays the VBA Editor in Indicates whether the
through a list of values. which you can create or worksheet grid appears
modify a macro for outlining the
the control. individual cells.

195