Microsoft Office Tutorials and References
In Depth Information
Your UserForms can also use other ActiveX controls. See “Customizing the Toolbox,”
later in this chapter.
A CheckBox control is useful for getting a binary choice: yes or no, true or false, on or off, and
so on. When a CheckBox is checked, it has a value of True ; when it’s not checked, the CheckBox
value is False .
A ComboBox control presents a list of items in a drop-down box and displays only one item at a
time. Unlike a ListBox control, you can set up a ComboBox to allow the user to enter a value
that doesn’t appear in the list of items.
Every dialog box that you create will probably have at least one CommandButton control.
Usually, your UserForms will have one CommandButton labeled OK and another labeled Cancel.
A Frame control is used to enclose other controls. You enclose controls either for aesthetic
purposes or to logically group a set of controls. A frame is particularly useful when the dialog box
contains more than one set of OptionButton controls.
You can use an Image control to display a graphic image, which can come from a file or can be
pasted from the Clipboard. You may want to use an Image control to display your company’s
logo in a dialog box. The graphics image is stored in the workbook. That way, if you distribute
your workbook to someone else, you don’t have to include a copy of the graphics file.
Some graphics files are very large, and using such images can make your workbook
increase dramatically in size. For best results, use graphics sparingly or use small
A Label control simply displays text in your dialog box.