I've added a drop down list which pulls its list data from another worksheet,
this all works exactly as expected, except there is not type-ahead feature.

For example, if the list contains the following entries:

ABC
DEF
GHI
JKL

I would assume once I typed in 'D' in the list, 'DEF' would be displayed.

Is there any way of enabling this? The customer requires this as their list
may contain a few hundred entries and they do not want to scroll through the
lists to find an entry.

Thanks.
David

Depends on how you create that dropdown list.

If you use the combobox from the control toolbox toolbar, you can get this
effect.

Launen wrote:

I've added a drop down list which pulls its list data from another worksheet,
this all works exactly as expected, except there is not type-ahead feature.

For example, if the list contains the following entries:

ABC
DEF
GHI
JKL

I would assume once I typed in 'D' in the list, 'DEF' would be displayed.

Is there any way of enabling this? The customer requires this as their list
may contain a few hundred entries and they do not want to scroll through the
lists to find an entry.

Thanks.
David

--

Dave Peterson

Think Debra covers this at her page:
http://www.contextures.com/xlDataVal10.html
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Launen" wrote in message
...
I've added a drop down list which pulls its list data from another
worksheet,
this all works exactly as expected, except there is not type-ahead
feature.

For example, if the list contains the following entries:

ABC
DEF
GHI
JKL

I would assume once I typed in 'D' in the list, 'DEF' would be displayed.

Is there any way of enabling this? The customer requires this as their
list
may contain a few hundred entries and they do not want to scroll through
the
lists to find an entry.

Thanks.
David