View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Kathy
 
Posts: n/a
Default 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