ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   checkbox activation (https://www.excelbanter.com/excel-programming/317590-checkbox-activation.html)

burksmg

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


Stephen Knapp

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