Unique 'TextTips' Based on Hovered Over Cell Values (Hyperlinked)

[Jenn68]

With reference to this post ... https://www.excelforum.com/excel-pro...heet-cell.html, I am struggling to figure out a VBA solution to one of the components of my original post there. The solution provided fundamentally works (thank you Kokosek and Lewis), but I have not been able to figure out yet how to display the unique 'texttip' for the row that the user is hovering over. The code, as it is now, displays the same 'texttip' for each cell in that particular range (all the + in column I display "Heavy", ~ in column J display "Moderate" and "Light for column J's - ). I need to enhance those messages based on the row as: (apologize for being unable to display tabular, there are three columns of data illustrated here)

Sym Row Message
+ 13 > 10 cm
+ 14 > 10 cm
+ 15 > 10 cm
+ 16 > 5 mm
+ 17 >5 mm
+ 18 >5 mm
+ 19 > 45 kph

~ 13 5-10 cm
~ 14 5-10 cm
~ 15 5-10 cm
~ 16 1-5 mm
~ 17 1-5 mm
~ 18 1-5 mm
~ 19 20-45 kph

- 13 <5 cm
- 14 <5 cm
- 15 <5 cm
- 16 <1 mm
- 17 <1 mm
- 18 <1 mm
- 19 <20 kph

Would anyone like to assist me in how to best approach this ... to display the appropriate 'texttip' based on which cell within the range the pointer is positioned? I suspect it might involve this portion of code, but I am unsure how to get the value for "srow" identified in my commented out lines of code. Perhaps it can't be done?

Please Login or Register  to view this content.

[LJMetzger]

Hi,

Try the attached copy of your modified file. The '-' sign column worked intermittently for me, so I changed it to 'x' and it worked every time for me. You may want to try to change it back to '-' sign, and see how it works for you.

In the future, please upload your sample file to the thread - you will get better and quicker responses, as responders want to do as little work as possible testing and looking for files.

Changed code follows:

Please Login or Register  to view this content.

NOTE: Had to replace 'Case' with 'xCase' and 'Select' with 'xSelect' to get past Excelforum firewall

Lewis

[Jenn68]

Hi Lewis! Thank you so much. I was on the right track with my own guessing, but you cleaned things up for me. Working well!

[LJMetzger]

I was happy to help. Your commented out lines in the code made things easy.