Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-10-2020, 02:00 PM
PrincessApril PrincessApril is offline Allow User to Define Tooltip Upon Data Entry Windows 10 Allow User to Define Tooltip Upon Data Entry Office 2019
Competent Performer
Allow User to Define Tooltip Upon Data Entry
 
Join Date: Nov 2019
Posts: 102
PrincessApril is on a distinguished road
Default

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

Reply With Quote
Reply

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
Allow User to Define Tooltip Upon Data Entry Insert input box into macro to allow user to define search term Hoxton118 Word VBA 3 05-19-2014 02:03 AM
Allow User to Define Tooltip Upon Data Entry 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft