Datasheet

21
Chapter 1: Using Macros and Form Controls
6
7
You can add the controls listed in the following table to your worksheets.
CONTROL CONTROL NAME DESCRIPTION
Button Runs an associated macro when clicked
Combo box A menu that displays a list of items
Check box Selects or deselects an option
List box Displays a list of items for selection
Radio button Selects one of a group of items
Group box Groups related controls, such as radio buttons, 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
Spinner Scrolls up and down through a list of numeric values
7 Right-click the control twice and then
click it to place it in Design mode.
To cancel Design mode, click any cell in
the worksheet.
To remove a control, place it in Design
mode and then press Delete.
6 Place your mouse pointer on the control
and when the mouse pointer turns into a
four-sided arrow drag the control to
change the location.
03_591598-ch01.indd 2103_591598-ch01.indd 21 6/11/10 1:41 PM6/11/10 1:41 PM