Allow User to Define Tooltip Upon Data Entry

PrincessApril · #10 06-11-2020, 02:18 PM

I tried adding

Code:

.ShowInput = False

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel to be edited by multiple user but relevant user should see only his data	dolphine4u	Excel	1	07-24-2016 12:40 AM
Date/Time Formula for Entry level XL user	talon1driver	Excel	2	09-18-2014 02:32 PM
Insert input box into macro to allow user to define search term	Hoxton118	Word VBA	3	05-19-2014 02:03 AM
User Form to Automate Entry in report	Panzer	Word VBA	2	08-22-2012 04:17 AM
define a mail merge data source using unc (universal naming convention)	charlesandrews	Mail Merge	0	08-21-2012 10:33 AM