Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab to accept entry from list
I have created a fairly simple worksheets that includes two columns with data
validation that requires users to select entries from a list of values. Is there a way to set it up so that users can type the first few characters in the entry instead of having to pull down and scroll through the list to find the item? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab to accept entry from list
DV list dropdown has no autocomplete feature.
You will have to use a ComboBox to achieve this but it does use VBA so may not be suitable. See Debra's Contextures site for how-to. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP On Fri, 14 Sep 2007 11:58:01 -0700, Rod from Corrections wrote: I have created a fairly simple worksheets that includes two columns with data validation that requires users to select entries from a list of values. Is there a way to set it up so that users can type the first few characters in the entry instead of having to pull down and scroll through the list to find the item? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab to accept entry from list
Thanks very much for your advice!
"Gord Dibben" wrote: DV list dropdown has no autocomplete feature. You will have to use a ComboBox to achieve this but it does use VBA so may not be suitable. See Debra's Contextures site for how-to. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP On Fri, 14 Sep 2007 11:58:01 -0700, Rod from Corrections wrote: I have created a fairly simple worksheets that includes two columns with data validation that requires users to select entries from a list of values. Is there a way to set it up so that users can type the first few characters in the entry instead of having to pull down and scroll through the list to find the item? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab to accept entry from list
Not using data|validation.
Rod from Corrections wrote: I have created a fairly simple worksheets that includes two columns with data validation that requires users to select entries from a list of values. Is there a way to set it up so that users can type the first few characters in the entry instead of having to pull down and scroll through the list to find the item? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoComplete list should accept ENTER key as well as TAB | Excel Discussion (Misc queries) | |||
Cell in Excel spreadsheet will not accept entry of specific data v | Excel Worksheet Functions | |||
Validation list that also allows user entry? | Excel Worksheet Functions | |||
drop down list - save the entry | Excel Discussion (Misc queries) | |||
double-clicking a list entry | Excel Discussion (Misc queries) |