UserForms. See also custom dialog boxes
Activate event, 438, 661
ActiveX controls, 118
ActiveX controls, new, 447
Add100Buttons procedure, 874-875
AddControl event, 661
BeforeDragOver event, 661
BeforeDropOrPaste event, 661
buttons , 100, 874-875
Caption property, 431
charts, displaying, 524-526, 959
CheckBox control, 416
checklist, 448
Click event, 661
Close button, disabling, 456
closing, 428-429
color , selecting, 523-524
ComboBox control, 416
ComboBox control, Help system, 790-792
CommandButton control, 417, 450
controls, 118
controls, adding, 415-416
controls, adding at design time, 872-875
controls, adjusting, 421-422
controls, aligning, 421
controls, movable, 510-511
controls, referencing, 444-445
creating, 414, 430-433
creating programmatically, 875-883
data validation, 436
DblClick event, 661
Deactivate event, 438, 661
design-time manipulations, 872-875
dialog boxes and, 27
displaying, 427-428
displaying based on variable, 428
displaying charts, 600-602
displaying, code for, 433
displaying modeless, 427
dynamic creation, 878-883
Error event, 661
event-handler procedures, 429-430
event-handler procedures, adding, 435-436
events, 437-439, 631, 661-662
events, keyboard-initiated, 440-441
events, mouse-initiated, 440
events, SpinButton controls, 439-440
external controls, 480-482
Frame control, 417
GetOption function, 878-881
grid lines, 421
Help system, 784, 788-792
hiding, 960
Image control, 417, 510-511
Initialize event, 438, 661
input, 118
inserting, 414-415
KeyDown event, 661
KeyPress event, 661
KeyUp event, 661
Label control, 418, 517
Layout event, 661
ListBox control, 418, 450-451
loading, 428
MakeForm procedure, 876-877
maximum size , 516
menus, 450-451
minimum size, 516
MouseDown event, 661
MouseMove event, 661
MouseUp event, 661
MultiPage control, 418, 479-480
multiple controls, one event handler, 520-522
OptionButton control, 418
overview, 413
progress indicator, MultiPage control and, 497-498
progress indicator, standalone, 493-494
puzzle, 529-530
QueryClose event, 439, 661
ranges, selecting, 452-453
RefEdit control, 418, 452-453
RemoveControl event, 661
resizable, 515-519
Resize event, 661
run time creation, 876-877
run time manipulations, 872-875
Scroll event, 661
ScrollBar control, 418
shapes , 961
size, 457-458
SpinButton control, 419
splash screens, 454-455
TabStrip control, 419
Tag property, 443
templates, creating, 447-448
Terminate event, 439, 661
testing, 434-435
Text Tools utility, 538
Text Tools workbook, 537
TextBox control, 419
title bar, none, 511-513
Togglebutton control, 419
toolbar simulation, 513-515
unloading, 960
worksheets, scrolling, 458-460
worksheets, zooming, 458-460
Zoom event, 661