Datasheet
Chapter 1: Using Macros and Form Controls
21
You can add the controls listed in the following table to your worksheets.
CONTROL CONTROL NAME DESCRIPTION
Button Runs an associated macro when the user clicks it.
Combo box Displays a list of items as a menu.
Check box Selects or deselects an option.
Spinner Scrolls up and down through a list of numeric values.
List box Displays a list of items for selection.
Radio button Selects one of a group of items when the user clicks it.
Group box Places related controls together.
Label Provides information about an associated control.
Scroll bar Increases or decreases a value when the user clicks the arrows or drags the bar.
6
6 Place your pointer on the border of a control and
drag the control to change its location.
The control appears on the worksheet.
•
Right-click the control to place it in design mode.
•
To cancel design mode, click any cell in the
worksheet.
•
To remove a control, right-click the control to
select it and then press Delete.
04_132302 ch01.qxp 7/27/07 9:20 PM Page 21