How to link an Image to a cell value
 

:confused:
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

How to link an Image to a cell value
 

Hi H,

See JE McGimpsey's technique at:

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


---
Regards,
Norman


"hhalle" wrote in
message ...

:confused:
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

How to link an Image to a cell value
 

Thanks Norman,

That's just it!

I'll go on and try it out!.

Regards,
Hans

Norman Jones Wrote:
Hi H,

See JE McGimpsey's technique at:

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


---
Regards,
Norman


"hhalle" wrote
in
message ...

:confused:
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



--
hhalle

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