Excel - A Macro to display comment on mouse-over

December 2016



Issue


I need a macro to display comments upon placing mouse cursor over a particular cell. How can this be implemented?

Solution


To be included in a macro:
With Range("A1")  
.AddComment  
.Comment.Shape.Fill.UserPicture "C:\folder\Name_of_Image.jpg"  
End With 

Thanks to michel_m for this tip on the forum.

Related :

This document entitled « Excel - A Macro to display comment on mouse-over » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.