Page 289 - Excel Progamming Weekend Crash Course

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

264 Saturday Evening

Both the ComboBox and ListBox controls display a list of items from which the user
can select.
Use the CheckBox, OptionButton, or ToggleButton control for on/off options.
The RefEdit control enables the user to select a range of cells in a worksheet.

QUIZ YOURSELF

1. What’s the main difference between the CheckBox control and the OptionButton
control? (See the “A Summary of Controls” section.)
2. How do you configure a TextBox control so it can contain multiple lines of text?
(See the “The TextBox Control” section.)
3. How do you add items to the list of a ComboBox control? (See the “The ComboBox
Control” section.)
4. What does it mean to set the Default property of a CommandButton to True? (See
the “The CommandButton Control” section.)
5. Describe two ways to create a group of OptionButton controls. (See the “The
OptionButton Control” section.)