Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-09-2019, 04:16 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
Advanced Beginner
Allow User to Define Tooltip Upon Data Entry
 
Join Date: Nov 2019
Posts: 36
PrincessApril is on a distinguished road
Default Allow User to Define Tooltip Upon Data Entry

Hi all,



I am hoping for some direction rather than a full solution here so that I can try to research it myself. I'm just having trouble with where to look for info.

So I have rows full of cells where the user chooses an integer from 1 to 32. These represent work units (each unit = 15 minutes). The user is logging how much time was spent on various tasks each day. The user performs work throughout the day and continually logs the units (2 here, 1 there, 4 there, etc.), working from left to right. I have the daily and monthly totals being autocalculated.

However, it is easy to forget which units correspond to work with which clients (every unit is tied to a client). A user might not remember if s/he entered units earlier in the day and accidentally enter those units twice or not at all. It would be wonderful if I could allow the user to be prompted to enter a tooltip where they could enter the client's initials that go with each unit entry. So each cell still displays an integer, but when the user hovers over it, the tooltip shows the client's initials as a memory recall tool. The user would have to be prompted to enter those initials after selecting the integer unit from my existing dropdown I suppose. I could make separate columns of course, but then I will have a whole lot of columns, and I try not to make users scroll horizontally whenever possible. That's why I was thinking of a tooltip.

Any guidance on what topics I should be researching? I want to put the effort in myself of course, but I'm just not sure where to start.
Reply With Quote
  #2  
Old 12-09-2019, 07:10 PM
Logit Logit is offline Allow User to Define Tooltip Upon Data Entry Windows 10 Allow User to Define Tooltip Upon Data Entry Office 2007
Expert
 
Join Date: Jan 2017
Posts: 278
Logit is on a distinguished road
Default

This resource is one method. Look at example answer #1 / Edit #2 about middle of
page :

Display Excel VBA message box when a cell within a range changes AND meets a given criteria - Stack Overflow

Let me know if you need assistance.
Reply With Quote
  #3  
Old 12-10-2019, 07:29 AM
p45cal p45cal is offline Allow User to Define Tooltip Upon Data Entry Windows 10 Allow User to Define Tooltip Upon Data Entry Office 2019
Expert
 
Join Date: Apr 2014
Posts: 359
p45cal has a spectacular aura aboutp45cal has a spectacular aura aboutp45cal has a spectacular aura about
Default

Try entering data into the light blue shaded area in the attached.
It needs a cell to be selected rather than hovered over.
Attached Files
File Type: xlsm msofficeforums44017ToolTip on data entry.xlsm (17.3 KB, 3 views)
Reply With Quote
  #4  
Old 12-17-2019, 09:55 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
Advanced Beginner
Allow User to Define Tooltip Upon Data Entry
 
Join Date: Nov 2019
Posts: 36
PrincessApril is on a distinguished road
Default

Wow, you guys are awesome. That is so great!
Reply With Quote
Reply

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


All times are GMT -7. The time now is 02:58 PM.


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