Data Validation - Stop/Cancel options

[EssKayKay]

I have a cell with assigned Data Validation criteria. If the user inputs an erroneous value it returns the “Stop” Error Alert with the Retry/Cancel/Help buttons.

Upon entering data in the cell another routine is triggered. Is it possible that if the user selects the “Cancel” option the remaining routine would also be cancelled? That is, something like Exit Sub upon selecting Cancel.

Thanks for viewing,
Steve

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Data Validation - Stop/Cancel options?
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[EssKayKay]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Data Validation - Stop/Cancel options?
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

I totally understand but I did not receive a workable solution to my situation on the other forum (maybe there is none), so I decided to go back to my previously all time favorite - MrExcel. Maybe that was a mistake and I should probably reevaluate, BUT, I'm still hopeful someone here will be able to assist. I like your suggestion to provide a link to my "other" post - thanks.

Here's the link --
Data Validation - Stop/Cancel options?

Sorry,
Steve