Closing User Form

[Dohko]

Hi

I have a userform that's called via a macro.
How can I program the form so that when I press the ESC key it will close it and stop running the program? If I click the X on the form it closes it but I need it to work with the esc key


thanks

[Leith Ross]

Hello Dohko,

The only time a UserForm processes the KeyUp, KeyDown, and KeyPress events is when there are no controls on the form to take the focus.

Sincerely,
Leith Ross

[Dohko]

So if there is an OK button then pressing ESC wont quit the form?

[Leith Ross]

Hello Dohko,

You can if the "OK" button has the focus. The button can process the keyboard input and check for "ESC". Here is an example...

Please Login or Register  to view this content.

Sincerely,
Leith Ross