Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'd like to enable the Escape key to cancel a userform. My form has a single
multipage control with two pages. I have inserted a commandbutton with its Cancel property set to True and have hidden the commandbutton by sending it behind the Multipage control. Its Click event is: Private Sub CommandButton1_Click() Unload Me Set frmInstructions = Nothing End Sub I encounter two problems with this: First, the Escape key unloads the form only when the second page of the multipage is visible (I'd like Esc to cancel the form at any point). Second, I can't select the button for editing after it is hidden behind the multipage (need definitive selection method). -- Thanks in Advance, Jay |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HOW TO DO ENABLE ENABLE THE QUERY PARAMETER BUTTON? | Excel Worksheet Functions | |||
VBA select default Don't Enable / Enable macros Setting | Excel Programming | |||
Userform to enter values and shown in same userform in list | Excel Programming | |||
Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
Activating userform and filling it with data form row where userform is activate | Excel Programming |