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 this
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 a
particular value in Excel
Example, Country name and its flag.

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

The flag is not saved as a bmp, ico or gif on disk but is on a separate
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 which
staands for Winner A, in the results, the walue of WA may be CRC (Costa
Rica)

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

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

Thanks


--
hhalle

Male
------------------------------------------------------------------------
hhalle's Profile: http://www.excelforum.com/member.php...o&userid=20829
View this thread: http://www.excelforum.com/showthread...hreadid=501526