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/