make my own list like formula autocomplete

  • Thread starter Thread starter Ryan
  • Start date Start date
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.
 
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
 
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
 
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
 
Back
Top