SEARCH
0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Prev | Current Page 52 | Next

Jim DeMarco

"Pro Excel 2007 VBA"


CHAPTER 1 n THE MACRO RECORDER AND CODE MODULES 37
TextBox: This allows entry or modification of text.
ComboBox: The ComboBox is a combination list box and text box. Users can either
choose an item from the list or enter a value in the text box.
ListBox: This is used to display a list of items from which the user can choose. The list can
be scrolled if it has more items than can be displayed at one time.
CheckBox: This creates a box that the user can click to select or deselect an item or to
show a true or false value.
OptionButton: This displays multiple choices from which the user can choose only one.
ToggleButton: This button is used for toggling on and off.
Frame: This is a graphical or functional grouping for controls. To group controls, draw the
frame first, and then place option buttons or check box controls inside the frame.
CommandButton: This creates a button the user can click to carry out a command.
TabStrip: This allows you to define multiple pages for the same area of a window or dialog
box in your application.
MultiPage: This presents multiple screens of information as a single set.
CHAPTER 1 n THE MACRO RECORDER AND CODE MODULES 38
ScrollBar: This provides a tool for quickly navigating through a long list of items or a large
amount of information. It is also useful for indicating the current position on a scale, or as
an input device or indicator of speed or quantity.
SpinButton: This is used in conjunction with another control to increment and decrement
numbers.


Pages:
40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64