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. |
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. |
All times are GMT +1. The time now is 03:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com