Drop down box with country list
- From: john liem <john.liem.1p9vhm@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 19 May 2005 06:58:47 +0000
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@xxxxxxxxxxxxxxxxxxxxxxxxxx wrote in
> message
> news:john.liem.1p8hhm@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>
> 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-
--
john liem
.
- Follow-Ups:
- Re: Drop down box with country list
- From: Bob Phillips
- Re: Drop down box with country list
- Prev by Date: can't right click
- Next by Date: Printing a User Form
- Previous by thread: Re: Drop down box with country list
- Next by thread: Re: Drop down box with country list
- Index(es):
Relevant Pages
|