Drop down box with country list

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


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
.

Relevant Pages

  • Drop down box with country list
    ... John. ... Bob Phillips Wrote: ... > You could easily find a site with all the countries in, ...
    (microsoft.public.excel.newusers)
  • Re: Jazz Guitarists that played for Monkees records
    ... Hal Blaine, Earl Palmer, Sharkey Hall, Jesse Sailes, John Guerin, ... Gibbons, Bob Bain, Dennis Budimer, John Gray, Bill Pitman, Al Casey, Al ... Hendrikson, Irving Ashby, Mundell Lowe, Mike Anthony, Lou Morell, Al Viola, ... Ray Pohlman, Arthur Wright, Nick Bonney, Toots Thielemans, Don Peake, ...
    (rec.music.makers.guitar.jazz)
  • Re: The infinite spinning rainbow wheel
    ... In addition to what John said ... ... > option only to find myself staring at the spinning beachball again. ... >> Hi Bob: ... >> The beachball is simply Word telling you it is "waiting for the system". ...
    (microsoft.public.mac.office.word)
  • Re: FS PINBALL MACHINES
    ... John P. Dayhuff wrote: ... > i'm wrong Bob. ... rare Gottlieb EM games come up on ebay or Mr. Pinball for sale. ...
    (rec.games.pinball)
  • Re: Have there ever been 2 greater champions sharing an era?
    ... Really makes tennis history a ... john and Hewitt and Sampras have nothing to do with this. ... say "john says Hewitt game surpassed Sampras" no matter what is being ... brain of Whisper 'Everyone' means 3 people Bob, ...
    (rec.sport.tennis)