Page 296 - Excel Progamming Weekend Crash Course

r540629 ch21.qxd 9/2/03 9:35 AM Page 271

SESSION

21

Advanced User Form Techniques

Session Checklist

✔ Using control events
✔ Tools for aligning and sizing controls
✔ Working with the z-order
✔ Controls and the tab order

n the previous two sessions, you learned the fundamentals of user form design and
some details about the controls available for user forms. This session goes a bit further,
I covering some of the more advanced aspects of user form design and use.

Using Control Events
The controls that are used on user forms can detect certain types of events. These events
are, for the most part, the result of user actions, such as clicking a control or pressing keys.
You have already seen one of these events, Click, used in some sample programs. Other
events for forms and controls are described in Table 21-1. These are not all the events that
are available to a programmer, but they are the ones you’ll need most often.

Table 21-1 Events Available for User Forms and Controls

Event Available for Occurs
Click Forms; most controls When the user clicks the object
DblClick Forms; most controls When the user double-clicks the object

Continued