Hover over cell - display value from other cell

[virtuosok]

Hi,
I understand it's only possible to do so via VBA?
I have a range B3:X17 on Tab1, and I wonder if by hovering over, let's say, cell C10 in Tab1, I can see an entry from cell C10 in Tab2 from within the same workbook - so that it pops up as a ScreenTip. Same for all other cells. Thanks in advance for any ideas!

 

[SQUIDD]

hi

so just checking, your sheet with the comments is called "Tab1"

 

[virtuosok]

It's called DM, but I have replaced references to "Tab1" with "DM" within VBA code...
The other tab is called DMhistory so likewise I substituted "Tab2" with "DMhistory" in VBA code.

 

[SQUIDD]

thats strange

so if you use this code

when you have the sheet with the comments in it active

it does not work?

Sub tryme()
For Each mycom In Application.ActiveSheet.Comments
    mycom.Shape.TextFrame.AutoSize = True
Next
End Sub

 

[virtuosok]

I tried the above code in my workbook and I realized that we're talking two different types of comment, so to say.
The first one, with the VBA code from the previous page in this thread, has comments of this sort:

...whereas if I insert "manual" comments into the worksheet to see how the "tryme" code works, I have classic Excel 365 comments:

Could that be the reason?