software

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
quot;NEDquot;,quot;Netherlandsquot;,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: www.excelforum.com/member.php...oamp;userid=20829
View this thread: www.excelforum.com/showthread...hreadid=501526Hi H,

See JE McGimpsey's technique at:

www.mcgimpsey.com/excel/lookuppics.html---
Regards,
Normanquot;hhallequot; gt; wrote in
message ...
gt;
gt;
gt; Hi,
gt;
gt; This was first posted on January 8th, six viewers but no ideas.
gt; I wonder if anyone has used something similar. I know you can do this
gt; in MS Access but I would like to try it in Excel.
gt;
gt; I and am looking for a way to display an Icon wihich is linked to a
gt; particular value in Excel
gt; Example, Country name and its flag.
gt;
gt; Seeing the Worldchampionship soccer is on its way I have an excel sheet
gt; to keep the scores and want to display the round winners with their
gt; relative flag.
gt;
gt; The flag is not saved as a bmp, ico or gif on disk but is on a separate
gt; sheet next to the cell with the country's code and name:
gt;
gt; A1,A2,A3
gt; quot;NEDquot;,quot;Netherlandsquot;,flag (it's not in the cell but 'floating' there.
gt;
gt; The idea is to have a empty sheet.
gt; In the cells the reference to a cell, let's say: A1 = WA which
gt; staands for Winner A, in the results, the walue of WA may be CRC (Costa
gt; Rica)
gt;
gt; So the value of reference WA = CRC. Elsewhere in another sheet there
gt; is a flag for Costa Rica, I would like to display the flag foor WA next
gt; to it and of course this is a variable since I do not know who will be
gt; WA.
gt;
gt; I would like to know if somebody has a solution or a small example of
gt; code which could do this in VBA for Excel
gt;
gt; Thanks
gt;
gt;
gt; --
gt; hhalle
gt;
gt; Male
gt; ------------------------------------------------------------------------
gt; hhalle's Profile:
gt; www.excelforum.com/member.php...oamp;userid=20829
gt; View this thread: www.excelforum.com/showthread...hreadid=501526
gt;

Thanks Norman,

That's just it!

I'll go on and try it out!.

Regards,
Hans

Norman Jones Wrote:
gt; Hi H,
gt;
gt; See JE McGimpsey's technique at:
gt;
gt; www.mcgimpsey.com/excel/lookuppics.html
gt;
gt;
gt; ---
gt; Regards,
gt; Norman
gt;
gt;
gt; quot;hhallequot; gt; wrote
gt; in
gt; message ...
gt; gt;
gt; gt;
gt; gt; Hi,
gt; gt;
gt; gt; This was first posted on January 8th, six viewers but no ideas.
gt; gt; I wonder if anyone has used something similar. I know you can do
gt; this
gt; gt; in MS Access but I would like to try it in Excel.
gt; gt;
gt; gt; I and am looking for a way to display an Icon wihich is linked to a
gt; gt; particular value in Excel
gt; gt; Example, Country name and its flag.
gt; gt;
gt; gt; Seeing the Worldchampionship soccer is on its way I have an excel
gt; sheet
gt; gt; to keep the scores and want to display the round winners with their
gt; gt; relative flag.
gt; gt;
gt; gt; The flag is not saved as a bmp, ico or gif on disk but is on a
gt; separate
gt; gt; sheet next to the cell with the country's code and name:
gt; gt;
gt; gt; A1,A2,A3
gt; gt; quot;NEDquot;,quot;Netherlandsquot;,flag (it's not in the cell but 'floating' there.
gt; gt;
gt; gt; The idea is to have a empty sheet.
gt; gt; In the cells the reference to a cell, let's say: A1 = WA which
gt; gt; staands for Winner A, in the results, the walue of WA may be CRC
gt; (Costa
gt; gt; Rica)
gt; gt;
gt; gt; So the value of reference WA = CRC. Elsewhere in another sheet
gt; there
gt; gt; is a flag for Costa Rica, I would like to display the flag foor WA
gt; next
gt; gt; to it and of course this is a variable since I do not know who will
gt; be
gt; gt; WA.
gt; gt;
gt; gt; I would like to know if somebody has a solution or a small example
gt; of
gt; gt; code which could do this in VBA for Excel
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt;
gt; gt; --
gt; gt; hhalle
gt; gt;
gt; gt; Male
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; hhalle's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=20829
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=501526
gt; gt;--
hhalle

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