Thread: CheckBox Event
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default CheckBox Event

Go into design mode (the green-blue triangle on the controls toolbar) and
then double-click the checkbox. This will take you into the VBIDE with a
skeleton event macro where you can add your code.

Don't forget to come out of design mode at the end.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"devin " wrote in message
...
I got a number of checkboxs on a sheet. They all come from the controls
tool box. I need to identify when anyone of these check boxs were
clicked with out actually writing code to every check box. An event if
you will. I need this event to trigger some other code. Can anyone help
me, I'm kinda new at this. Thanks!


---
Message posted from http://www.ExcelForum.com/