Choose the Right Control

The Toolbox includes 15 standard controls that you can draw on forms. Table 20-5 lists those controls and describes their use.

Table 20-5. Built-in form controls (Forms 2.0)

Control

Toolbox icon

Use to

Label

Display text the user can’t change.

TextBox

Display text the user can edit. Text boxes can display scrollable text.

ComboBox

Allow selections from a drop-down list of choices. Combo boxes can include a text box where the user can type a choice not in the list.

ListBox

Allow selections from a scrollable list of choices.

CheckBox

Get or display yes/no choices.

OptionButton

Get or display a set of either/or choices.

ToggleButton

Get or display on/off options.

Frame

Group option buttons or other related controls.

CommandButton ...

Get Programming Excel with VBA and .NET now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.