On cancel GoTo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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:
 
I think the problem is Input Box reads cancel as "". So if you wrote

If RecordsDate = "" Then GoTo XIT

It should work
 
Thanks It worked perfectly

AKphidelt said:
I think the problem is Input Box reads cancel as "". So if you wrote

If RecordsDate = "" Then GoTo XIT

It should work
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Path & File Name 3
Cancel Input Box error 16
Choosing offset on condition found in combobox change colour of cell?? 2
Macro Problem 4
InputBox: Separate CANCEL and 0 3
Cancel InputBox 6
Differentiate between False and Zero for Input Box return? 3
Setting "r" to = range selected in an IF statement? 4

Back
Top