Is there a way to display cell comments when mousing over anywhere in the cell rather than over the comment indicator icon?
I've come up with a way to detect a mouse over icon:
Public Function MouseOverDetect
msgbox "Event fired"
End Function
and in the cell that is to fire the event put:
=HYPERLINK(MouseOverDetect(),Sheet2!C2)
where sheet2!C2 is the value the cell that fires the event is supposed to be displaying.
However, I dont want to display a message box or userform when the event fires, just the cell comment for the cell in question. There are around 100 cells on the sheet I want to do this with.
Bookmarks