Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
Error Handling | Excel Programming | |||
Error handling with a handling routine | Excel Programming | |||
Escape On Error methods in Subs | Excel Programming | |||
How to escape this error message | Excel Programming |