View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stephen Knapp Stephen Knapp is offline
external usenet poster
 
Posts: 34
Default 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