Page 306 - Excel Progamming Weekend Crash Course

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

Session 21 — Advanced User Form Techniques 281

REVIEW
In this session you learned some of the more advanced aspects of designing and using user
forms.
Each control responds to certain user events, and you can write code that is exe-
cuted when an event occurs.
Controls on the form are by default aligned with a grid. You can change the size of
the grid or turn it off.
The VBA Editor’s Format menu contains many commands that assist you in placing,
aligning, and sizing controls.
When two or more controls overlap, the one that is displayed on top is controlled by
the z-order.
When a form is displayed, pressing Tab moves the focus from control to control in
an order determined by the tab order.

QUIZ YOURSELF
1. What event occurs when the data in a control changes? (See the “Using Control
Events” section.)
2. How do you change the spacing of the form design grid? (See the “The Form Grid”
section.)
3. When selecting multiple controls to align, to which control are the others aligned?
(See the “Control Placement and Alignment Tools” section.)
4. At runtime, how do you bring a control to the top of the z-order? (See the
“Overlapping Controls and the Z-Order” section.)
5. What property determines whether a control can receive the focus by tabbing?
(See the “Focus and the Tab Order” section.)