Country Flags

[Busymanjohn]

Here's a question that should generate some discussion. In Excel 2003, is there a way to have a country flag show in say cell B1 depending on the country name in say cell A1. So if A1 said Croatia, B1 would should the country flag.

 

[srinidhi]

check out this link in chandoo & u shld do a bit of modification to suite u r needs.


http://chandoo.org/wp/2009/07/13/product-catalogs/

 

[Busymanjohn]

Hi srinidhi ,,,, a good idea, but I don't want to use a drop down menu, was looking for a solution that if I have a number of cells ,,, say A1:A10 each with a different country, then their corresponding country flag would appear in B1:B10. I'm not sure it is possible though ... any idea?

 

[Luke M]

Check this out:

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

 

[srinidhi]

Busymanjohn, it is simple, in A1 type in the country name & in B1 paste the image(picture)of the flag. adjust the cell height according to the picture.


Thats all u want or would u like something else