LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 124
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
drop down list autocomplete mikelmendit Excel Worksheet Functions 6 October 10th 08 10:18 PM
autocomplete from specific list stremetzky Excel Worksheet Functions 8 January 13th 08 07:19 PM
Validation List Autocomplete Guilherme Loretti Excel Discussion (Misc queries) 2 March 22nd 06 01:07 AM
Autocomplete from a list on the worksheet mrdata Excel Worksheet Functions 3 March 4th 06 08:11 PM
autocomplete from a drop down list Dude Excel Discussion (Misc queries) 1 December 8th 04 03:29 AM


All times are GMT +1. The time now is 10:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"