How to Automate Display of Pictures Using Comments with VBA

We can automate the display of pictures using comments with VBA in Microsoft Excel. The display of pictures automatically can be useful in a variety of situations like if you wish to check an inventory item quickly or wish to identify an employee.

First we learn the process of displaying pictures in a comment box using a standard procedure. Next we use Visual Basic for Applications or VBA to automate the display of images in our Excel worksheet.

Watch the video before you study the VBA code given below:

You may like to watch the video on YouTube
Sub showPic()
For Each cell In Selection
MyPicture = “C:\Users\takyar\Pictures\PillowCases\” & cell.Value & “.jpg”
With cell.AddComment
.Shape.Fill.UserPicture MyPicture
End With
Next cell

End Sub

Download a sample file:

Further reading

Published by

Dinesh Kumar Takyar

Welcome to! My aim is to help you learn MS Excel including VBA. I always felt that a good way to learn something was to find solutions to problems in that domain. That is why I share these Excel videos with you. Mostly these are questions asked during my corporate training sessions. I've been training individuals and companies in computers since 1991. I did my B. Sc. (Vordiplom), M. Sc. (Diplom) and Ph.D. (Dr. rer. nat.) from Hamburg, Germany. The best thing about solving some of my visitor's questions is that I also gain new insights. For more Excel VBA solutions you may like to visit my YouTube channel: For a structured Excel VBA training course online you can visit:

One thought on “How to Automate Display of Pictures Using Comments with VBA”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.