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.