|
|
#5
06-10-2020, 02:00 PM
|
|||
|
|||
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
|
| Tags |
| define, multicolumn, tooltip |
|
|
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 |
Windows 10 
Office 2019
Threaded Mode