Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CheckBox Event
I got a number of checkboxs on a sheet. They all come from the control
tool box. I need to identify when anyone of these check boxs wer clicked with out actually writing code to every check box. An event i you will. I need this event to trigger some other code. Can anyone hel me, I'm kinda new at this. Thanks -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
CheckBox Event
Use this technique documented by John Walkenbach.
http://j-walk.com/ss/excel/tips/tip44.htm Handle Multiple UserForm Buttons With One Subroutine although the example is done for commandbuttons, it is equally applicable to any control on the control toolbox toolbar and may be employed for controls on a userform or worksheet. -- Regards, Tom Ogilvy "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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checkbox Event | Excel Discussion (Misc queries) | |||
How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
Action Event, CheckBox, Add Row and Textbox | Excel Discussion (Misc queries) | |||
Click event for checkbox from Forms toolbar | Excel Discussion (Misc queries) | |||
checkbox event handling function | Excel Worksheet Functions |