Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
On cancel GoTo
RecordsDate = InputBox("Please enter Bank Records Backup date (m-d-yyyy)of file to recall", "Bank Records Recall") On Cancel GoTo XIT Below I have a line XIT: When I click on the Cancel button the routine doesn't go to XIT: |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
On cancel GoTo
I think the problem is Input Box reads cancel as "". So if you wrote
If RecordsDate = "" Then GoTo XIT It should work "Oldjay" wrote: RecordsDate = InputBox("Please enter Bank Records Backup date (m-d-yyyy)of file to recall", "Bank Records Recall") On Cancel GoTo XIT Below I have a line XIT: When I click on the Cancel button the routine doesn't go to XIT: |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
On cancel GoTo
Thanks It worked perfectly
"AKphidelt" wrote: I think the problem is Input Box reads cancel as "". So if you wrote If RecordsDate = "" Then GoTo XIT It should work "Oldjay" wrote: RecordsDate = InputBox("Please enter Bank Records Backup date (m-d-yyyy)of file to recall", "Bank Records Recall") On Cancel GoTo XIT Below I have a line XIT: When I click on the Cancel button the routine doesn't go to XIT: |
Reply |
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 | |||
msgbox yes=password & goto sheet3, no= cancel | Excel Programming | |||
Disabling 'Cancel' option when saving work (Yes/No/Cancel) | Excel Programming | |||
Cancel button to cancel the whole macro | Excel Programming | |||
Cancel Macro is user selects 'cancel' at save menu | Excel Programming |