Programming Excel with VBA and .NET

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 ...