If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
make my own list like formula autocomplete
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. |
#2
|
|||
|
|||
make my own list like formula autocomplete
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 On Fri, 13 Nov 2009 13:54:01 -0800, Ryan wrote: 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. |
#3
|
|||
|
|||
make my own list like formula autocomplete
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 "Ryan" wrote in message ... 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. |
#4
|
|||
|
|||
make my own list like formula autocomplete
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 "Ryan" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|