| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set value of checkbox on userform without triggering Click event
I have a userform with several checkboxes on it. I have one "master"
checkbox that is supposed to be able to set all checkboxes true or false based on its own state. So basically, if master checkbox is true then set all checkboxes true, else if it's false then set all checkboxes false. The annoying thing though is when it sets the value of each individual checkbox it runs the code associated with each checkbox's click event. This is slowing down my spreadsheet considerably. Is it possible to set the value of a checkbox without Excel executing the code associated with it's click event? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Click event for checkbox from Forms toolbar | Excel Discussion (Misc queries) | |||
| userform label double-click goes to click event | Excel Programming | |||
| Click Checkbox Event | Excel Programming | |||
| Triggering click event of a menu in vba | Excel Programming | |||
| Triggering click event of a menu in vba | Excel Programming | |||
Threaded Mode
