Drop down box with country list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

john liem - 19 May 2005 07:58 GMT

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

> Enter the countries in a range (say column M) and then add a Data
> Validation
> (DataValidation) and select the List option with a formula of say
> =M1:M100
> or however many countries
>
> --
> HTH
>
> Bob Phillips
>
> "john liem" john.liem.1p8hhm@news.officefrustration.com wrote in
> message
> news:john.liem.1p8hhm@news.officefrustration.com...-
>
> I have an excel application where I need a drop down box with all the
> country' names listed, ready to use (like the Microsoft Date and Time
> Picker Control). Is there a way to get it and how? John
>
> --
> john liem-

Signature

john liem

Reply to this Message

Bob Phillips - 19 May 2005 10:53 GMT

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.

Signature

HTH

Bob Phillips

> 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
[quoted text clipped - 26 lines]
> > --
> > john liem-

Reply to this Message