Office® XP Development with VBA

What Controls Are Available?

The Toolbox contains 14 different controls that should meet just about any programming need. They are described briefly in Table 19.2, and you can use the VBA Help system to explore the details.

Table 19.2. The available controls for creating a User Form.

Control	Description
Label	Displays text that cannot be edited by the user.
TextBox	Displays text that the user can edit.
ListBox	Displays a list of items from which the user can select.
ComboBox	Combines the function of a TextBox and a ListBox.
CheckBox	Displays an option that can be turned on or off.
OptionButton	Similar to a CheckBox, but only one OptionButton in a group can be “on” at one time. To create a group of OptionButton controls, place a Frame control on the User Form ...