Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use Keyboard with KeyDown and KeyUp
I am working on a sheet that has keyboard shortcuts. I want to use
keyboard buttons to control the worksheet. For example, if I press the "q" key down, I want TextBox1 to appear. When the "q" key is released (KeyUP), TextBox1 should go away. TextBox1 can be generated in the code under the KeyDown sub, and deleted after KeyUp, I just don't know how to catch the keyboard key actions with KeyDown and KeyUp. Thanks, Donny |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use Keyboard with KeyDown and KeyUp
On Sep 22, 10:01 am, Donny wrote:
I am working on a sheet that has keyboard shortcuts. I want to use keyboard buttons to control the worksheet. For example, if I press the "q" key down, I want TextBox1 to appear. When the "q" key is released (KeyUP), TextBox1 should go away. TextBox1 can be generated in the code under the KeyDown sub, and deleted after KeyUp, I just don't know how to catch the keyboard key actions with KeyDown and KeyUp. Thanks, Donny Hello Donny, You can catch the KeyUp and KeyDown events on a VBA UserForm. There are no equivalent events for an Excel Worksheet. Although a short cut key can be assign directly to macro, this doesn't mean keyboard events are also associated with the same macro automatically. Up and down movement of Worksheet keystrokes can only be monitored by using advanced API code techniques. Sincerely, Leith Ross |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Distinguish between '<' and '.' with KeyUp? | Excel Programming | |||
keydown event | Excel Programming | |||
keydown event | Excel Programming | |||
Detect MsgBox keyUp | Excel Programming | |||
keydown event | Excel Programming |