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?

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?

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?

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