Hi, we are using excel 2016 and files used are normally xslx or xslm.
I am trying find a way that will pop up a picture (snapshot of a table) when user move mouse to specific cell or select the cell. I cannot use drop down list in data validation because the cell already contain a list. The picture is to help user to decide which to select.
We don't like the input message in data validation because the box is too small and unable to format message into a manner for easy understanding. For example, we wanted the message to look like this (row by row):
mgrp_SS1 = sgrp_AA2
mgrp_RS2 = sgrp_RR3
but using the input message, visually it looks like:
mgrp_SS1 =
sgrp_AA2
mgrp_RS =
sgrp_RR3
The size of the box, split the sentence into two which makes the message not as clear cut and straightforward.
Thats why I thought we can compile the message into a table (row by row), snap shot the table to add in as tooltip when cell is selected or hover over.
I hope we don't have to use VB for this but if there is a need to use VB, I hope it will be a simple one because there is no strong VB knowledge people in the office.
Bookmarks