I have setup a drop down menu that has 600 names. It works. They go to that cell click on the down arrow and they can scroll down and find the employee name they are looking for. However they want to be able to type in for example "brown" and it will take them down to the browns. I am doing this with a data validation, selected list.
I would suggest you use a combobox to do this. You can link the combobox to the same cell where you data validation list is, and all formulas will stay the same. You will set the source for the combobox to the same range you are using for the data validation list.
An option that gets you halfway there is to
1. Sort your name list in alphabetical order
2. Add initial letters before each set of alphabetical names (i.e. A, B, C)
3. Then the user types the first letter into the Data Val Cell and the dropdown will open to the names that begin with that letter
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks