![]() |
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 |
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 |
All times are GMT +1. The time now is 07:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com