Data Validation - Stop/Cancel options?

What is the other routine? Are you using Worksheet_Change? What functionality does it perform? It would be better to actually show us your code, and best of all to attach your file (see yellow banner at the top of the page).

Worksheet_Change detects only if the cell content changes. When you type an invalid value into the cell, that is a change. So your routine is triggered, and there is no going back. Then when Data Validation rejects it on Cancel, that's another change. VBA cannot detect that you clicked Cancel. For the behavior you want, you would have to develop the entire data validation in VBA instead of using built-in data validation.

However, depending on what you want to do when the cell is updated, alternative solutions might be possible. It all depends on what you're trying to do.

Well Jeff, sorry for being so deficient.

I was a bit hesitant to post the worksheet. I must first stress, I am not a programmer. I’m sure you and others would be amazed at how sloppy my coding is, but for the most part it works. Attached is a copy my worksheet. This is a work in progress so not all operations are complete.


Example:
My current quest is when an unacceptable value is entered into cell K10 without anything entered into K9. As a test, enter 1-1-23 in K10. This will trigger the Validation error. This is where if “Cancel” is selected, I would like the remaining code to Exit Sub or something.

If you feel I’m asking for a bit too much here, please simply disregard this post.

Thanks,
Steve K.