Page 282 - Excel Data Analysis

15 537547 AppC.qxd 3/4/03 11:56 AM Page 268

APPENDIX

VBA AND EXCEL EVENTS QUICK REFERENCE

(CONTINUED)

EXCEL EVENTS QUICK REFERENCE (CONTINUED)

UserForm Events
EVENT DESCRIPTION
Activate Excel activates the UserForm.
AddControl Excel adds a run-time control to the UserForm.
BeforeDragOver The user performs a drag-and-drop operation.
BeforeDropOrPaste The user releases the mouse button to paste the data from the drag-and-drop operation.
Click The user clicks the mouse on a UserForm object.
DblClick The user double-clicks the mouse on a UserForm object.
Deactivate The user deactivates the Userform.
Error Excel detects a UserForm control error.
KeyDown The user presses a key.
KeyPress The user presses an ANSI key. An ANSI key produces a visible character.
KeyUp The user releases a key.
MouseDown The user presses a mouse button.
MouseMove The user moves a mouse on the UserForm.
MouseUp The user releases the mouse button.
QueryClose Excel closes the UserForm.
RemoveControl Excel removes a control from the UserForm at run time.
Scroll The user repositions a Scroll box on a control.
Terminate Excel terminates the UserForm.
Zoom The user zooms the UserForm.
Workbook Events
EVENT DESCRIPTION
Activate Excel activates the workbook.
AddinInstall An add-in installs a workbook.
AddinUninstall An add-in uninstalls a workbook.

268