Drop down list - auto fill capability?

[frateg8r]

I have a drop down list in a cell; it currently has 800+ items in the list, so finding one can be time consuming (relatively speaking.) My specialty app programmer has created a way to enter 4-5 characters in a field, press enter, and it pulls up the first 10 matching items. He calls this an "auto fill" feature, for lack of a better name when put on the spot to identify it in a technical way just a moment ago.

I'd like to be able to do something similar in my Excel workbook. For example, in the cell, type in "CNABC" and have the list go to the first or nearest match, so that I can then select that first item or scroll up/down as I normally would.

I'm pretty sure I saw somebody else post on a similar question, but that was over a year ago, and I have no idea what keywords to use to search on it, except "drop down", and well, that could take months looking through all those.

Thanks in advance, as always, to you XL whizzes out there!

XL2003 ON WIN7

 

[Oeldere]

but I have all source info on a different sheet

Then you could work with defined names

Excel 2007 => formula => define names

 

[SlammanDan]

I Difined The Source names but not sure excactly where to put it in the code.

 

[Oeldere]

The defined name can be used as name for the datavalidation

Excel 2007 => data => datavalidation => list => =defined name

instead the range on your worksheet you use the defined name.

=defined name

 

[SlammanDan]

Thank You Very Much
Dan

 

[Oeldere]

Thanks for the reply.

Glad I could help.

 

[Antonf]

I downloaded the example:
1. When I click on the cell no dropdown box opens?
2. When I start typing a month in the cell it autocompletes fine!
3. Followed the steps religiously, but it won't work in my own sheet...

Using Excel 2010

 

[haider378]

Re: Drop down list - auto fill capability - macro to activate the list

Hi,

I have created auto complete list using information and code provided in link.

is it possible to add macro/code to activate the combo box in cell instead of using mouse double click