Add image to cell comment box

[jpenndcl]

I have a set of data with text in one cell and images in a cell adjacent the text to illustrate the text. I am trying to figure out how to add a comment to the cell containing the text and take the image in the adjacent cell and put it in the comment. Is there a way to do this, or do I have to write a macro that saves the images as their own files and then insert the image files into the comment?

 

[jpenndcl]

What you could do is save the workbook as a web page. That should create a separate directory with all the images in it. You can then use those with the Userpicture property.

Good idea! I'll try that. Thank you everyone!