| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Drop down box with country list
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 |
|
#2
|
|||
|
|||
|
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" wrote in message .. . 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using symbols for drop down list boxes? | Excel Worksheet Functions | |||
| Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
| automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
| formatting drop down list | Excel Discussion (Misc queries) | |||
| Drop List Referencing | Excel Worksheet Functions | |||
Linear Mode
