Embed image in cell

Thanks, that code really worked.

http://www.excelforum.com/excel-misc...e-in-cell.html

by the way , why there is no option for adding a picture manually to the comment of a cell?
when editing a comment the Insert picture from file from the Insert menu is disabled ! (Offic XP)

and can you please edit the code so the Width and Height of the comment box is set exactly to the dimensions of the picture? (that is how to get the exact width and height of the picture being inserted from code in excel ?)

thanks.

Originally Posted by AceX

Thanks, that code really worked.

by the way , why there is no option for adding a picture manually to the comment of a cell?
when editing a comment the Insert picture from file from the Insert menu is disabled ! (Offic XP)

and can you please edit the code so the Width and Height of the comment box is set exactly to the dimensions of the picture? (that is how to get the exact width and height of the picture being inserted from code in excel ?)

thanks.

I found the solution to my question here:

http://www.vbaexpress.com/forum/show...87&postcount=8

Please Login or Register  to view this content.

AceX,

You're thread move to their own thread as per forum rules below which you should read

Thanks for sharing you're solution. I will mark it solved for you this time

VBA Noob