Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo box - input Range | Excel Discussion (Misc queries) | |||
Combo Box input range automatic update | Excel Discussion (Misc queries) | |||
How can I calculate user input from a combo box into a formula? | Excel Worksheet Functions | |||
Variable Input Range for Combo Box | Excel Worksheet Functions | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |