Macro: Insert Comment with Picture

[Screamer]

Hi,

I've recently created a spreadsheet with the aim of recording errors in a product.

The easiest way to show these errors is sometimes with a picture and here is the problem. When I use autofilter the pictures do not get filtered. I would therefore like to add the pictures as a comment instead however do not want to go through the long process of clicking all the boxes each time. Idealy I don't want to collect the image from a separate file but would like to paste it directly into a comment.

I have tried various ways of recording Macro's but have had no success.

I have also found the below code after various searches but I don't have a great enough understanding to minipulate it.

Can any one help me?

Thank you,

Stephen

Please Login or Register  to view this content.

[romperstomper]

That code is for exporting images, not inserting them. What exactly did you mean by:

Idealy I don't want to collect the image from a separate file but would like to paste it directly into a comment

Where would the macro come in and where are you copying the pictures from?

Cross-posted here.

[Screamer]

Hi romperstomper,

Thanks for the quick response,

I would like the macro to be run on a selected cell with a coommand button. The picture will come from a CAD model as a print screen, so i don't want to have to then save this a seperate file to insert later, idealy the print screen can be pasted directly into the comment.

Thanks,

Stephen

[Screamer]

Problem solved here: http://www.mrexcel.com/forum/showthr...=1#post1978712

altough I would still be interestreed in the above solution as it offers a much more user friendly view.

Thanks,

Stephen

[romperstomper]

I think you would have to write the image to a disk file and load from there; I don't know of a way to paste one in