I tried adding
after the final instance of
Code:
If .InputMessage = "" Then .Delete
but same issue noted above (I know I'm guessing hehe)
Now I'm thinking maybe
Code:
Selection.Validation.Delete
(but that seems to be geared toward clearing all parts of the validation, and I just want to clear the previous note if the cell becomes blank)
I had been searching for vba related to tool tips and it took me a while to realize that we are borrowing the text from the data validation for this macro
Playing a bit on my own as well now that work day is finished.