Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there anyway to cancel the "X" cancel button at the top of UserForms?
Alternatively, is there a way to re-route the "Esc" key to the "Done" button on my userform? The problem is that I have code that calls this form, and does an infinite loop while checking the form's "IsDone" custom property. When the user cancels the form, I get an "Automation Error", because the code calling the form is still looking for a .IsDone property, but the object no longer exists! I have tried putting setting the IsDone property to TRUE in the Terminate event... but it does not work. Or, is there another solution to this problem that I do not know about? Any help would be appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
message box without ok or cancel button | Excel Discussion (Misc queries) | |||
Cancel Button | Excel Programming | |||
Input Box Cancel Button | Excel Programming | |||
input box cancel button | Excel Programming | |||
Button To Cancel Macro | Excel Programming |