Add Background Photos / Images to Comments in Excel

Add to Favorites
Add background images and photos to your comments in Excel with this macro. This macro uses a really cool feature in Excel that allows you to set a photo or image from your computer as the background image for a comment. This allows you to spruce up your comments to make them less boring or simply in line with the them of your workbook or worksheet.

This macro will add a comment and then add the background image to that comment. However, you can just delete this line Range("A1").AddComment ("Comment text goes here.") if you want to use this macro to set a background image to an existing comment in your Excel spreadsheet.

To use this macro, replace the range references A1 with the reference of the cell where you would like to add a comment or just put a background photo in a comment. The range reference for both lines in the macro must be exactly the same. Also, replace this text C:\image.jpg with the file path location of the image on your computer which you want to set as the background fro the comment. You need to include all of the folders in the file path and the photo extension for the image for the macro to work correctly in Excel.

Where to install the macro:  Module

Excel Macro to Add Background Photos to Comments in Excel

Sub Insert_Comment_Add_Background_Picture()
'Macro to insert a comment in cell A1 and then set a picture or photo as the background for that comment

Range("A1").AddComment ("Comment text goes here.")

Range("A1").Comment.Shape.Fill.UserPicture "C:\image.jpg"

End Sub










How to Install the Macro
  1. Select and copy the text from within the grey box above.

  2. Open the Microsoft Excel file in which you would like the Macro to function.

  3. Press "Alt + F11" - This will open the Visual Basic Editor - Works for all Excel Versions.  Or For other ways to get there, Click Here.

  4. On the new window that opens up, go to the left side where the vertical pane is located. Locate your Excel file; it will be called VBAProject (YOUR FILE'S NAME HERE) and click this.

  5. If the Macro goes in a Module, Click Here, otherwise continue to Step 8.

  6. If the Macro goes in the Workbook or ThisWorkbook, Click Here, otherwise continue to Step 8.

  7. If the Macro goes in the Worksheet Code, Click Here, otherwise continue to Step 8.

  8. Close the Microsoft Visual Basic Editor window and save the Excel file. When you close the Visual Basic Editor window, the regular Excel window will not close.

  9. You are now ready to run the macro.


Excel Forum