A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

make my own list like formula autocomplete



 
 
Thread Tools Display Modes
  #1  
Old November 13th, 2009, 10:54 PM posted to microsoft.public.excel.misc
Ryan
external usenet poster
 
Posts: 551
Default 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  
Old November 14th, 2009, 12:02 AM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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  
Old November 14th, 2009, 01:16 AM posted to microsoft.public.excel.misc
L. Howard Kittle
external usenet poster
 
Posts: 516
Default 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  
Old November 14th, 2009, 03:23 PM posted to microsoft.public.excel.misc
Tom Hutchins
external usenet poster
 
Posts: 722
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:12 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.