Drop down box with country list

[john liem]

Thanks Bob, however what I want is a dropdown which we can find in the
web site applications (e.g. airways ticketing) where we can use choose
a country using the drop down with a complete list of world's
countries.
In Data Validation method, I have to re-type all the possible country's
names.
John.

 

[Bob Phillips]

John,

You could easily find a site with all the countries in, and paste that in,
such as http://dir.yahoo.com/Regional/countries/.

Linking to a web site would be difficult to incorporate in the DD, plus it
may be off-line, it seems better to me to just copy it down.