Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox activation
How could I activate/de-activate a checkbox in a user form from the keyboard (i.e. without needing to click in it with the mouse)... maybe by pressing "X" or using the enter key to activate and either toggel it with those same keys or use the spacebar to de-activate? -- burksmg ------------------------------------------------------------------------ burksmg's Profile: http://www.excelforum.com/member.php...o&userid=16744 View this thread: http://www.excelforum.com/showthread...hreadid=319468 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox activation
The form object can respond to events for KeyPress, KeyDown, and KeyUp.
Write code in one of those for your "hot key" to change the checkbox as desired. Steve in Ohio "burksmg" wrote: How could I activate/de-activate a checkbox in a user form from the keyboard (i.e. without needing to click in it with the mouse)... maybe by pressing "X" or using the enter key to activate and either toggel it with those same keys or use the spacebar to de-activate? -- burksmg ------------------------------------------------------------------------ burksmg's Profile: http://www.excelforum.com/member.php...o&userid=16744 View this thread: http://www.excelforum.com/showthread...hreadid=319468 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
activation key | Excel Discussion (Misc queries) | |||
UserForm Activation | Excel Programming | |||
On Edit activation | Excel Programming | |||
program activation | Excel Programming | |||
Ctl-X activation of macros | Excel Programming |