Macro Help - Insert an image into a Cells Comment Box

[lynch]

Hi Guys,

I was looking at the below link,

http://www.mrexcel.com/forum/showthread.php?t=72113

And basically I need the above doing, but as a macro.

Could someone help me produce it?

1)user highlight the target cell
2)user clicks a button to start the macro
3)the macro then brings up a dialog box which allow the user to select the image from c:\my pictures
4)the image is then inserted into the comment box

Any genius help?

Thanks for your time

 

[Andrew Poulsom]

Welcome to MrExcel.

Here you are:

http://www.contextures.com/xlcomments03.html#Picture

 

[lynch]

Hi Andrew,

Thanks for the quick reply! I may be having teething problems so please excuse my cheekyness!

This seems to paste a chart into my cell and not a picture?

Also it dosnt allow the user to select an image but asks to name the image?

Again sorry for being slow, this is new to me but I am having much fun trying! any ideas?

 

[Andrew Poulsom]

You'll have to amend the macro if you want to select a picture on disk. You can use the FileDialog property to enable the user to select one.

 

[lynch]

Thanks Andrew, Ive got this working!

Somebody buy this man a beer!!