Page 211 - Excel Data Analysis

11 537547 Ch10.qxd 3/4/03 12:03 PM Page 197

FORM CONTROLS 10

THE VISUAL BASIC EDITOR TOOLBOX (CONTINUED)

The Visual Basic Editor Toolbox appears only when you
select a UserForm in the Visual Basic Editor. The Toolbox
contains all the controls that you can add to your custom
UserForm. See the section "Create a Custom Dialog Box"
for more information about adding Toolbox controls.

Arrow ToggleButton
Use this control to select objects in order to size or Enables you to create a button that looks either pressed
move them on a UserForm. or unpressed. The pressed state returns a result of True
and the unpressed state returns a result of False.
Label
TabStrip
For adding text to a UserForm. The user cannot alter
text labels on a UserForm; you add labels for Enables you to create a multipage, or tabbed area for a
informational purposes only. section of your UserForm. You can place tab strips on
each page of the UserForm.
TextBox
Enables the user to input text. MultiPage
You use these to create tabled dialog boxes, which let the
ComboBox user switch between pages of options in the dialog box. By
default, the MultiPage control adds only two pages to your
Enables a user to either click an item from the list or UserForm. You add more pages by right-clicking one of
type an appropriate value in the text box.
the Page tabs and selecting the New Page option.
ListBox
ScrollBar
Enables you to present a list of items from which a user
can select an item. Enables the user to scroll through information not
originally shown on the screen or to indicate a position
on a scale, such as a rating level.
CheckBox
Enables the user to select or deselect options. Typically, SpinButton
a CheckBox control returns a value of True if it is
selected and False if it is not selected. Enables the user to specify a value by clicking one of
the arrow buttons to increment or decrement the value.
Use either a TextBox control or a Label control to
Frame
display the current value of the SpinButton control.
Enables you to group controls. For display purposes only.
Image
OptionButton
Use the Image control to add a graphic to the UserForm.
Enables the user to select from a list of items. You place Excel stores the graphic within the worksheet, so if you
two or more OptionButton controls in a group so that distribute the worksheet, the graphic is included. You
when you select one control, the other controls are can assign the graphic any of the following file formats:
deselected. .bmp, .cur, .gif, .ico, .jpg, .wmf.
CommandButton RefEdit
The user clicks this to perform a specific option. When Consisting of a text field and a button, this enables the
you create a CommandButton control, you specify the user to select a range of cells from a worksheet. When
text that appears on the button as part of the control the user clicks a button, the corresponding dialog box
properties. minimizes so that the user can drag the cursor across
the worksheet to select the desired range of cells.

197