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