Make typing "jump" to matching item(s) in drop-down list?
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
|