Excel - A Macro to display comment on mouse-over

October 2016


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


To be included in a macro:
With Range("A1")  
.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.