Macro for filling an Excel cell with the content of a graphics file, for instance rose.jpg and then to sort columns on those cells that contain the gr

[HarrySiers]

Hello Forumers,

Is it possible to fill an Excel cell with the content of a graphics file, for instance a graphics file rose.jpg by manually clicking on a number of cells in column A, and then to sort colums on those cells that contain the graphic?

Harry

 

[HarrySiers]

You need to put the code in the worksheet event. In the VB editor, you double click on the sheet where you want the action to happen, on the pulldown menu, you select Worksheet. On the pulldown menu further to the right, you select BeforeDoubleClick. Then paste code there.

For further info, please read the following page:

Events In Excel VBA

Thanks again for the explanation and the reference to Events in VBA!