R
Ron Perkins
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
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