| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I make a routine run after the 'cancel' butten is pressed .
Basically I have a macro which contains a vbYesNoCancel message box. I need
the macro to run a sub-routine when the user clicks 'cancel'. At the moment it just escapes out of the macro and stops. I don't seem to be able to manipulate the vbCancel as an elseif for the user response. Is there any kind of onCancel functionality or another way to run a sub-routine when the user clicks cancel? Or do I have to create my own dialog box from scratch? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workbook_BeforeClose(Cancel As Boolean) - Cancel won't work | Setting up and Configuration of Excel | |||
| Why should Service Pack make a difference in this routine? | Excel Programming | |||
| TRAPPING PRESSED BUTTON | Excel Programming | |||
| Which button was pressed? | Excel Programming | |||
| ComboBox DropDown when Key is pressed | Excel Programming | |||
Threaded Mode
