Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 06-11-2020, 07:11 AM
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
Red face

Thank you again. At first I thought this was what I was after (when I mass delete cells with previous notes, the notes appear to go away, but then after I enter a numeric value again, the old note reappears in the textbox. So I think the current code is removing the previous note from the visual tooltip but not from the textbox itself, at least not completely). I'd like to, if possible, clear off the previous note only if the cell becomes blank. An example of what I'm looking for in the hopes of clarifying:
  • User enters some number (say 2) and is prompted to enter a note. (works in both iterations so far and should be retained)
  • User enters some note ("blah blah"). (works in both iterations so far and should be retained)
  • User deletes the numeric value and cell becomes blank.
  • The "blah blah" note would be cleared (not only from the visual tooltip but from the textbox itself, the one where the user initially entered the note).
  • User enters some value (say 3), and is prompted for a note, but the textbox is blank (user enters "some text")
  • User changes the 3 to a 4 (user still prompted to enter a note and the "some text" note is still there (works in both iterations so far and should be retained--the only exception is for when a user deletes a cell value and the resulting cell is blank, in which case note should be cleared from both visual tooltip and textbox field).

Thank you again for your kind assistance!
Reply With Quote
 

Tags
define, multicolumn, tooltip

Thread Tools
Display Modes


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 12:35 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