Combo Box using Key Input
 

I'm using a combo box selection to find that cell on the
worksheet. The Combo Box works fine if I only use the
mouse to make the selection. I use the "On Change"
event. I canNOT get the key entry method to work. I want
it to work like it does in Access, where you can type and
it keeps matching your input until you hit the "Enter"
key. When I type my first letter it automatically goes to
the first match and ends the cycle there. The
on "KeyPress" event does not capture the "Enter" key. I'm
using Excel 2000. Help PLEASE
Thanks!!!
Perk

Combo Box using Key Input
 

Ron,

How about Textbox1_Exit or Textbox1_KeyDown events?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Ron Perkins" wrote in message
...
I'm using a combo box selection to find that cell on the
worksheet. The Combo Box works fine if I only use the
mouse to make the selection. I use the "On Change"
event. I canNOT get the key entry method to work. I want
it to work like it does in Access, where you can type and
it keeps matching your input until you hit the "Enter"
key. When I type my first letter it automatically goes to
the first match and ends the cycle there. The
on "KeyPress" event does not capture the "Enter" key. I'm
using Excel 2000. Help PLEASE
Thanks!!!
Perk