Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-14-2014, 01:57 PM
bolandk bolandk is offline Mouseover cell to indicate mouse pointer location based on Specific Row/Column values Windows 7 64bit Mouseover cell to indicate mouse pointer location based on Specific Row/Column values Office 2010 32bit
Novice
Mouseover cell to indicate mouse pointer location based on Specific Row/Column values
 
Join Date: May 2014
Posts: 1
bolandk is on a distinguished road
Default Mouseover cell to indicate mouse pointer location based on Specific Row/Column values


Good afternoon internet,
I'm working with a large spreadsheet which tracks personnel qualification data. I have created a matrix where quals are in the top row, and names down the first column (see example). Each cell in the matrix is populated with a checkbox which are activated upon personnel achieving the various quals.

The amount of data has gotten quite vast, and in the interest of avoiding mistakes while updating the sheet, I’m trying to figure out if it’s possible to have either comment boxes, or some other form of text box, appear when simply holding the mouse over a cell. The contents of the popup would need to reference to values in a defined row and column, in this case Name and Qual#.

I’ve searched through forums, and have come up pretty empty. If it’s not possible not to worry, but if it is I’d love to know how.

Cheers
Attached Files
File Type: xlsx Example.xlsx (37.1 KB, 9 views)
Reply With Quote
  #2  
Old 05-15-2014, 08:22 AM
gebobs gebobs is offline Mouseover cell to indicate mouse pointer location based on Specific Row/Column values Windows 7 64bit Mouseover cell to indicate mouse pointer location based on Specific Row/Column values Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Here's an example someone made that does rollover displays for a Periodic Table of Elements. It's pretty slick. Maybe you can adapt this code for your sheet.

http://optionexplicitvba.blogspot.co...-in-excel.html
Reply With Quote
Reply

Tags
check box, comment box, mouseover

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Powerpoint 2013 - Displaying Information when hovering (mouse pointer) over a picture MC1 PowerPoint 0 03-25-2014 07:48 AM
Mouseover cell to indicate mouse pointer location based on Specific Row/Column values Need help on duplicates in column; deciding which to keep based on other column nwcf Excel 3 01-31-2014 09:43 AM
Multiple Standard Rates Based on Location JohnTurner Project 3 01-23-2014 12:09 PM
change values based on cell ubns Excel 1 05-21-2012 06:28 PM
Word Mouse Pointer Problem kauedog Word 0 07-01-2009 06:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:55 AM.


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