Kathy

Debra Dalgleish has done the work for you.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben Excel MVP

On Tue, 22 Nov 2005 13:01:13 -0800, "Kathy"
wrote:

Dave, thank you for the reply, but it's over my head. I can use the toolbox,
but which of these functions would do what I need?

"Dave Peterson" wrote:

If you show the Control toolbox toolbar (view|Toolbars), you can add a Combobox
from that toolbar.

Rightclick on it and choose properties.

You'll be able to set the linkedcell, listfillrange, style, and matchentry
properties to what you want.

Kathy wrote:

Is there any way to make a drop-down list work so that typing causes a "jump"
to a matching item in the list? For example, if the list includes "chair,"
can it be formatted so that typing c-h- brings up "chair" in the drop-down
list?

This would be a huge time-saver in lengthy drop-down lists. We can make
Access do it--can Excel?

--

Dave Peterson