Page 276 - Excel Progamming Weekend Crash Course

n540629 ch20.qxd 9/2/03 9:35 AM Page 251

SESSION

20

Controls for User Forms

Session Checklist

✔ Summary of user form controls
✔ Common control properties
✔ Control details

t the heart of any user form is its controls. There are over a dozen controls available
to the programmer for user forms, and they cover a wide range of data display and
A entry needs. This session describes these controls and their properties, and shows
examples of how to use them.

A Summary of Controls
Excel provides 15 controls for you to place on user forms. Each control serves a specific pur-
pose and has its own set of properties, methods, and events. Table 20-1 provides a brief
summary of the available controls. The following sections cover some of the controls in more
detail. Space limitations preclude covering all of the controls in detail; those controls not
discussed are marked with an asterisk in the table. You can refer to the online help for
information on using these controls.

Table 20-1 Summary of Excel’s User Form Controls
Control Function
CheckBox Displays an option that can be turned on or off

ComboBox Combines the function of a TextBox and a ListBox
Continued