View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron Perkins Ron Perkins is offline
external usenet poster
 
Posts: 1
Default 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