One of the file I'm working on has a cookie cutter VBA code to default the data validation selection to "Yes", if an input is deleted.
Code:
Please Login or Register to view this content.
Recently added an additional indicator, with input selection being either "D" or "W". Is there an additional criteria to be added to the above code so that a certain data validation range (i.e., E6:E23) defaults to "Yes", when deleted, and another range (i.e., D6:D23) defaults to "D" when input deleted.
I attached a mock example, if that helps.
Thanks for the help in advance!
Bookmarks