Tooltip Look Up - Mouseover or Click

[ricky2k2]

I'm looking at condensing a wide worksheet, 100 columns of specific location names, into something more aesthetically pleasing.

I have a list that contains a location name and it's corresponding acronym. When a user mouses over the acronym on the worksheet with the 100 columns I'd like for the location name to display. I've mocked up an example and attached it.

Furthermore, is there a non VBA solution. I tried searching for lookups and data validation to no avail.


I feel that clicking into the cell and the tooltip displaying may be easier for our end user; however, share your thoughts.

Thanks!

[CK76]

Other than manually creating Comment notes... you'd need VBA.

Here's sample code.
In Standard Module:

Please Login or Register  to view this content.

In Workbook module:

Please Login or Register  to view this content.

Then in Worksheet Module for "Data" sheet:

Please Login or Register  to view this content.

See attached.

[MickG]

If you run the code below (Just Once) you will create a Hyperlink "ToolText" for the Cells in sheet "Data" row 1.
Each cell in row 1 of sheet data will have a "ToolTip" text relating to Location name in column 1 of sheet "Locations".

Please Login or Register  to view this content.

Regards Mick

[CK76]

...create a Hyperlink...

Nice! I like it much better than comments.

[MickG]

Thanks for the feedback
Regrds Mick

[ricky2k2]

Thank you solved.

[MickG]

You're welcome