Excel - A Macro to display comment on mouse-over

March 2017



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


Published by aakai1056.
This document, titled "Excel - A Macro to display comment on mouse-over," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).