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.
ControlDescription
LabelDisplays text that cannot be edited by the user.
TextBoxDisplays text that the user can edit.
ListBoxDisplays a list of items from which the user can select.
ComboBoxCombines the function of a TextBox and a ListBox.
CheckBoxDisplays an option that can be turned on or off.
OptionButtonSimilar 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 ...

Get Office® XP Development with VBA now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.