How to link an Image to a cell value

[hhalle]

Hi,

This was first posted on January 8th, six viewers but no ideas.
I wonder if anyone has used something similar. I know you can do thi
in MS Access but I would like to try it in Excel.

I and am looking for a way to display an Icon wihich is linked to
particular value in Excel
Example, Country name and its flag.

Seeing the Worldchampionship soccer is on its way I have an excel shee
to keep the scores and want to display the round winners with thei
relative flag.

The flag is not saved as a bmp, ico or gif on disk but is on a separat
sheet next to the cell with the country's code and name:

A1,A2,A3
"NED","Netherlands",flag (it's not in the cell but 'floating' there.

The idea is to have a empty sheet.
In the cells the reference to a cell, let's say: A1 = WA whic
staands for Winner A, in the results, the walue of WA may be CRC (Cost
Rica)

So the value of reference WA = CRC. Elsewhere in another sheet ther
is a flag for Costa Rica, I would like to display the flag foor WA nex
to it and of course this is a variable since I do not know who will b
WA.

I would like to know if somebody has a solution or a small example o
code which could do this in VBA for Excel

Thank

 

[Norman Jones]

Hi H,

See JE McGimpsey's technique at:

http://www.mcgimpsey.com/excel/lookuppics.html

 

[hhalle]

Thanks Norman,

That's just it!

I'll go on and try it out!.

Regards,
Hans