Hi all,
Is there a way to add a condition into the VBA so that, if the cell becomes blank, it will remove the previous text that was entered into the tooltip (but not the tooltip validation prompt)?
Maybe something like the following, but I'm not sure what to put for the "then" portion to delete the tooltip contents without removing the tooltip validation prompt for the next time the cell changes.
Code:
If Target.value = "" Then
End If