Customizing Dialog Boxes Menus And Toolbars

VISUAL BASIC EDITOR TOOLBOX

The Visual Basic Editor Toolbox only displays when you The Toolbox contains several different standard select a UserForm in the Visual Basic Editor. The controls that you can add to a userform. You can also toolbox contains all of the controls that you can add to create custom controls and add them to the Toolbox. your custom UserForm. See the section "Create a See the section "Create Custom Controls" for more Custom Dialog Box" for more information about information on adding custom controls. adding Toolbox controls.

Label

For adding text to a UserForm. Not designed to interact with the UserForm, you add labels for informational purposes only.

CommandButton

The user clicks this to perform a specific option. When you create a CommandButton control, you specify the text that displays on the button as part of the control properties.

TextBox

Enables the user to type text.

MultiPage

To create tabbed dialog boxes, which enable the user to switch between pages of options on the dialog box.

By default, when you add the MultiPage control to your UserForm it only creates two pages. You can add additional pages by right-clicking one of the Page tabs and selecting the New Page option.

ComboBox

Enables a user to either click an item from the list or type the appropriate value.

ListBox

For presenting a list of items from which a user can select a desired item.

ScrollBar

Enables the user to scroll through information not on the screen, or to indicate a position on a scale, such as for providing a rating level.

CheckBox

Enables the user to select or unselect options. Typically a CheckBox control returns a value of True if it is selected and False if it is not selected.

SpinButton

Enables a user to specify a value by clicking one of the arrow buttons to increment or decrement the value. Use with either a TextBox control or a Label control that displays the current value of the SpinButton control.

OptionButton

Enables the user to select from a list of items. You have two controls in a group so that when you select one control, the other controls are unselected.

ToggleButton

Enables you to create a button that looks either pressed or unpressed, with the pressed state returning a value of True, and the unpressed state returning a False value.

Image

Use the Image control to add a graphic to the UserForm. Excel stores the graphic within the worksheet, so if you distribute the worksheet, Excel includes the graphic. You can assign the graphic any of the following file formats: .bmp, .cur, .gif, .ico, .jpg, .wmf.

Frame

For display purposes. Acts as a container for grouping controls.

RefEdit

Consisting of a text field and a button, this enables the user to select a range of cells from a worksheet. When the user clicks a button, the corresponding dialog box minimizes so the user can drag the cursor across the worksheet to select the desired range of cells.

TabStrip

Enables you to create a multipage area for a section of your UserForm.

0 0

Post a comment