Hi,
I have a procedure that runs on Worksheet_Change. (Only if the target.column=2).
In that same column, each cell has Data validation to prevent the input of any wrong value/text.
My problem now is that even if the data validation stops the input, the Worksheet_change procedure runs.
is there any form to catch if the data validation stops the input. (And so stoping the Worksheet_Change macro from running?)
Thank you very much.
Bookmarks