The event handler is pre-determined by the name of the control.
Event handlers procedures must be placed in the corresponding userform module.
|Activate||Occurs when the userform is displayed or reactivated.|
This event will only fire:
if the userform is visible. (A userform loaded with the Load statement is not visible until you use the Show method)
and when you switch between userforms.
This event will NOT fire:
when you switch between the application and a modeless userform.
|AddControl||Occurs when a control is added to the userform at run-time.|
|BeforeDragOver||Occurs when a drag and drop operation is in progress while the mouse pointer is over the userform.|
|BeforeDropOrPaste||Occurs when the left mouse button is released and data is dropped and pasted ?|
|Click||Occurs when the left mouse button is clicked when over the userform. This does not fire when you click on a control on the userform.|
|DblClick||Occurs when the left mouse button is double clicked when over the userform.|
|Deactivate||Occurs when the userform loses focus because a subform is displayed.|
|Initialize||Occurs when the userform is loaded into memory, this is before the userform is displayed.|
|KeyDown||Occurs when any key is pressed while the userform is displayed.|
|KeyPress||Occurs when an ANSI key is presseed while the userform is displayed.|
|KeyUp||Occurs when any key is released while the userform is displayed.|
|Layout||Occurs when the size of a userform is changed at run-time.|
|MouseDown||Occurs when a mouse button is pressed ??|
|MouseMove||Occurs when the mouse pointer is moved over the userform at run time.|
|QueryClose||Occurs before a userform is closed or unloaded.|
|RemoveControl||Occurs when a control is removed from the userform at run-time.|
|Resize||Occurs when a userform is resized|
|Scroll||Occurs when the userform is scrolled ?|
|Terminate||Occurs when a userform is removed from memory as part of the clean up task|
|Zoom||Occurs when the userform is zoomed ???|
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext