| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Canceling the rest of a Sub
In the middle of a Sub the user is asked a question, if the user selects
Cancel I want the sub to stop. I was thinking something like this... If DocInfo.CancelInfo = True Then End Sub End If but I get an error from the above code. Any Ideas? Thanks in Advance. Rob |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Canceling the rest of a Sub
Almost the
If DocInfo.CancelInfo = True Then Exit Sub End If -- Gary's Student "Rob" wrote: In the middle of a Sub the user is asked a question, if the user selects Cancel I want the sub to stop. I was thinking something like this... If DocInfo.CancelInfo = True Then End Sub End If but I get an error from the above code. Any Ideas? Thanks in Advance. Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| canceling simplifying my fractions | New Users to Excel | |||
| Self canceling checkboxes | Excel Discussion (Misc queries) | |||
| Canceling a print job | Excel Programming | |||
| Canceling a UserForm | Excel Programming | |||
| Canceling a Macro that Has Been Scheduled | Excel Programming | |||
Linear Mode
