Changeable mouseover message

[malrog678]

Morning, here's something for you. I wasn't able to find solution to my question anywhere. However if this topic has appeared somewhere here already, please let me know where I can find my answers.

I've got 2 Excel sheets with linked information on both tabs. First one is a table containing a log of all employees names and their locker number. Second one is 'a map' of locker rooms with 'ticks' and 'crosses' to show current locker availability. Each locker has a corresponding cell next to it with user's name (vlookup to the log). To save space and make the layout look more like a real map, and be more readable, all cells which contain names are hidden. Now the pickle:
Every time when a user is opening the map, and hover over the cell (locker number) or click on it, I would like to see a comment-like message which will show name of the person who that locker belongs to. I don't want to insert a comment or use Data validation message box, because they will not change automatically when a locker changes owner.
Would it be possible with VBA though? Or maybe there is some other smart way of dealing with this? Surprise me ^^
And massive THANK YOU for even reading my post
M.

 

[James006]

Hello,

Jordan Goldmeier has created a very elegant solution ....:wink:

See his site ... and his Periodic Table of Elements ...brilliant ...!!!

https://optionexplicitvba.blogspot.com/2011/04/rollover-b8-ov1.html

HTH

 

[malrog678]

Thank you for your reply. However this is not exactly what I'm looking for. I thought rather of information looking like comment box, which appears when you hover over the cell, or when you click on it, but dissappears when you change the selection. I know that I could simply use comment option, but I would like the content of such comment to change automatically, when I update the table from the second worksheet. Is that even possible?? I'd like to think that everything is possible with a little bit of knowledge ^^

 

[malrog678]

Actually... I've just found it!
Some wonderful person created UDF code for dependent comments. I imagined the outcome a little bit different, but that'll do as well I've just changed the range of comments from visible to false, and it's almost perfect. If anyone wants to know the solution, please see below.

https://www.listendata.com/2013/04/excel-udf-dependent-cell-comment.html

 

[Logit]

.
https://superuser.com/questions/802...n-excel-macro-by-hovering-a-mouse-over-a-cell

 

[Logit]

Option Explicit


Private Sub Label1_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
    Label1.Caption = "This is your caption"
End Sub


Private Sub Label1_MouseUp(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
    Label1.Caption = ""
End Sub

 

[Logit]

.

Here are two example workbooks that demonstrate other means of having a "popup message" as well. By making the
objects invisible ...


https://www.amazon.com/clouddrive/share/6aFr5smwoQu25J7X2GiHfKdkS47TbHRnHg8dqdgGYAz

https://www.amazon.com/clouddrive/share/C9642LXErVTI1Z3iQh9kswzz4xxEcOajyaIS8PCgxqV