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 |
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 |
All times are GMT +1. The time now is 09:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com