Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down lists
Hey all,
I have a drop down list which contains names of 3,200+ companies. I used the menu option Data, Validation, and Allow List and point to cell AP2:AP3225 for the company list. Now, is there any way for me to type in the first few letters of the company name in the drop down list to allow that company (or companies) to appear first. For example, I'm looking for Prudential, I'll type Pru, and the drop down list will start at the first entry for Pru on the list. I hope I was clear in this explanation. Please help - if further clarification is needed, please let me know. Thanks in advance... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down lists
Use a Combo Box which has Autocomplete.
See Debra Dalgleish's site for more. http://www.contextures.on.ca/xlDataVal10.html On 17 Apr 2007 11:38:29 -0700, " wrote: Hey all, I have a drop down list which contains names of 3,200+ companies. I used the menu option Data, Validation, and Allow List and point to cell AP2:AP3225 for the company list. Now, is there any way for me to type in the first few letters of the company name in the drop down list to allow that company (or companies) to appear first. For example, I'm looking for Prudential, I'll type Pru, and the drop down list will start at the first entry for Pru on the list. I hope I was clear in this explanation. Please help - if further clarification is needed, please let me know. Thanks in advance... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down lists
Thanks - this helps tremendously!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists from multiple source lists | Excel Worksheet Functions | |||
Drop Down Lists: Allow option of adding own data if not in drop do | Excel Worksheet Functions | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions |