Insert specific picture into comment Macro help!

Hi there,

I have a large spreadsheet filled with products. I am trying to create a macro that will insert a comment with the picture of that product (so that it appears to 'pop up').

I can do this 1 by 1, however there are a few hundred on this sheet and this is a regular task for me.

Obviously, each product is different and needs a different picture. I have collated all pictures in one folder under C:\My Pictures\ and named them (Product code).jpg . The product codes are in column A of this sheet, and I would like the comments to appear in column B.

Please note that it also needs to lock the aspect ratio of the original picture and resize to be the same size as the original picture.

This is my first macro (recording doesn't seem to work) and here's what I have so far:

Please Login or Register  to view this content.

This works, however all it does it put one picture in cell A1.

Please help! Thank you in advance!

P.S. I am using Excel 2010.

Thanks you! Works great, but just one problem - the comments are sized according to the size of the first photo, is there any way to make each one sized individually according to its respective size?

Thank you again in advance!!