Userform Controls shortcut - close userform by escape key

i created a userform (call it userform1) that launches another userform (call this userform2). excel is hidden from user's view (by application.visible = false) upon launching userform1 (modal) so only the userforms are visible.
i wanted userform2 to hide or unload when i press the "{ESC}" button (escape key).

i tried:
1.) putting a command button (call it "Hidekey") setting it to default key and code it to close the userform2 (works but not ideal closing userform2 with the enter key on keyboard)

2.) assign an accelerator key ("H") on hidekey
(not ideal closing userform2 with two buttons to press - Alt+H)

3.) run code: (on initializing userform1)

Please Login or Register  to view this content.

Please Login or Register  to view this content.

-(the code above is not the accurate code) i made this one work, BUT, it only works when excel is Visible from user's view - pointless


so..
has anyone tried assigning like escape key to close a userform while excel is not visible (only the userform is visible) if yes, please help...
Or.. Does anyone have a better idea...

Try the KeyPress event procedure.

Please Login or Register  to view this content.

for some unknown reason, that didn't work...

i tried it while excel is visible and with the userform1 and userform2
tried it while excel is not visible and only userform1 and userform2 are visible
and i tried it again while only excel is showing - no userform loaded... (just to see if it would error or what at least)

(i added the code within userform2's module)
am i missing something extra i need to add?

so i just found out something....
check this out:


http://excelvbatipsforbeginners.blog...scape-key.html


goodness gracious, i set up hidekey with property "Cancel" to true, and it WORKS!!!