Part VI: Programming Excel with VBA
844
When you move the mouse pointer over a control in the Toolbox, the control’s name appears. To
add a control, click and drag it into the form. After adding a control, you can move it or change its
size.Table 41.2 lists the Toolbox controls.TABLE 41.2Toolbox Controls
Control Description
Select Objects Lets you select other controls by dragging.
Label Adds a label (a container for text).
TextBox Adds a text box (allows the user to type text).
ComboBox Adds a combo box (a drop-down list).
ListBox Adds a list box (to allow the user to select an item from a list).
CheckBox Adds a check box (to control Boolean options).
OptionButton Adds an option button (to allow a user to select from multiple options).
ToggleButton Adds a toggle button (to control Boolean options).
Frame Adds a frame (a container for other objects).
CommandButton Adds a command button (a clickable button).
TabStrip Adds a tab strip (a container for other objects).
MultiPage Adds a multipage control (a container for other objects).
ScrollBar Adds a scroll bar (to specify a value by dragging a bar).
SpinButton Adds a spin button (to specify a value by clicking up or down).
Image Adds a control that can contain an image.
RefEdit Adds a reference edit control (lets the user select a range).Cross-Reference
You can also place some of these controls directly on your worksheet. See Chapter 42 for details. n
Changing the properties of a control
Every control that you add to a UserForm has several properties that determine how the control
looks and behaves. You can change some of these properties (such as Height and Width) by
clicking and dragging the control’s border. To change other properties, use the Properties window.