make my own list like formula autocomplete

R

Ryan

I have a list of 1000s of items and i want the same formula that was used to
make the formula autocomplete. I want to start typing and a list drops down
of all the avaliable options. Like if in my list is apple and appricot i
want to type a and both of them appear in a list. It is for my squadron
commander and i cant figure it out. Any help is much appreciated.
 
G

Gord Dibben

There is no formula for autocomplete.............just internal programming
by Excel developers.

See help on ComboBox which will contain your list of values and supports
autocomplete.


Gord Dibben MS Excel MVP
 
L

L. Howard Kittle

Try this.

Sort your validation list and at the beginning of the A's enter a single A,
do the same for the beginning of the B's and all the way through to the Z's.

Click in the cell that has the drop down validation and type in the letter
of the list you desire... say you type in an O. DO NOT hit enter... leave
the cell in the edit mode (still selected) and now hit your down arrow.

Should take you to the O which is the top of the O list of selections.

HTH
Regards,
Howard
 
T

Tom Hutchins

You could use a combo box instead of data validation for your dropdown. The
combo box supports AutoComplete. Also, you can make the font bigger, etc.
Debra Dalgleish has complete instructions and a sample file on her excellent
Contextures site:

http://www.contextures.com/xlDataVal10.html

Hope this helps,

Hutch
 
Top