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