Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using escape key to exit a userform
hello all, and thanks in advance for any help on this.
i have a userform that is modal. the user's would like to be able to hit "esc" to exit it, along with using the Cancel button. is this a problem with a modal form? some info on the form: no button on the form has cancel set to true. the cancel button and the standard "close" button work fine. the form has a listbox, three buttons, and an optionbox group. only slecting is done on the form, no typing done by the user. for some reason, KeyDown is never activated on the form. nor is the keypress event. i was going to use those to capture if the user pressed the escape key. i am using Excel XP. thanks again! heidi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
using escape key to exit a userform
Heidi
some info on the form: no button on the form has cancel set to true. the cancel button and the standard "close" button work fine. the form has a listbox, three buttons, and an optionbox group. only slecting is done on the form, no typing done by the user. Setting the Close or Cancel button's Cancel property to True should do just that, regardless of the modality. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
using escape key to exit a userform
setting the cancel button to true would make the Escape
key work?? -----Original Message----- Heidi some info on the form: no button on the form has cancel set to true. the cancel button and the standard "close" button work fine. the form has a listbox, three buttons, and an optionbox group. only slecting is done on the form, no typing done by the user. Setting the Close or Cancel button's Cancel property to True should do just that, regardless of the modality. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
using escape key to exit a userform
right you are!! now i feel silly!! i didn't even know
that is what that feature did. thanks much!! -----Original Message----- Heidi some info on the form: no button on the form has cancel set to true. the cancel button and the standard "close" button work fine. the form has a listbox, three buttons, and an optionbox group. only slecting is done on the form, no typing done by the user. Setting the Close or Cancel button's Cancel property to True should do just that, regardless of the modality. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get userform Cancel button to invoke Exit Sub in calling macro? | New Users to Excel | |||
how do i make a button from a userform exit onto the document in . | New Users to Excel | |||
Disable Exit button on a UserForm | Excel Discussion (Misc queries) | |||
Opening a UserForm causes a crash in the Exit procedure (Which is never called) | Excel Programming | |||
Userform will not exit correctly | Excel Programming |