Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Lists
How can I select from my Drop Down lists by starting to type in the word?
For example, when I type in 'G', the names in the list beginning with 'G' will be selectable, when I add 'a'; I should be getting closer to selecting 'Gate' - for instance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Lists
Assuming you are speaking of DV dropdown lists, you cannot have autocomplete.
Use a ComboBox for that. See Debra Dalgleish's site for more. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP On Tue, 28 Aug 2007 13:36:03 -0700, e12762r wrote: How can I select from my Drop Down lists by starting to type in the word? For example, when I type in 'G', the names in the list beginning with 'G' will be selectable, when I add 'a'; I should be getting closer to selecting 'Gate' - for instance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists | Excel Worksheet Functions | |||
Drop-down lists | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
Drop Down Lists | Excel Discussion (Misc queries) | |||
Drop down lists | Excel Discussion (Misc queries) |