Error handling and escape key

J

Jeff

I'm trying to catch the {Escape} key and not allow it to put up an
error when my form is open. I have one of my command buttons set to
cancel true already, but it doesn't always catch the key press. I've
found some mention of using this

On Error GoTo ErrorHandler
Application.EnableCancelKey = xlErrorHandler

But I'm not really sure where to put these lines. I put them in my
UserForm_Initialize sub and I get 'Label not defined' for ErrorHandler
on compile. I'm not exactly sure where I should put this where it
will always be active. Any help would be appreciated.
 
R

Roger Whitehead

Have you tried Application.OnKey?

Application.OnKey "{ESC}", ""
will disable the Escape key,
Application.OnKey "{ESC}"
will re-enable


HTH
Roger
Shaftesbury (UK)
 
R

Roger Whitehead

Jeff,
You'll need the

ErrorHandler:

Label in the same module that calls it.




Have you tried Application.OnKey?

Application.OnKey "{ESC}", ""
will disable the Escape key,
Application.OnKey "{ESC}"
will re-enable

Not sure just how effective this would be in a user form though.

HTH
Roger
Shaftesbury (UK)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top