Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear All Checkboxes?
I'm developing a fairly complex Userform with 8 checkboxes. Is there a way to
control all boxes with one command. Say for example the end user selects 6 of the 8 boxes, then clicks run and then excel does its thing. My question is, is there anyway to clear all the checkboxes with one line, instead of checkbox1.value = false, checkbox2.value = false, etc...? Or another example would be if none of the checkboxes are selected then my msgbox would appear, but be able to do this in one line. I just want to simplfy the code from 8 lines to 1 line. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clear certain checkboxes | Excel Discussion (Misc queries) | |||
How to clear all checkboxes on a form? | Excel Worksheet Functions | |||
Macro to clear checkboxes | Excel Worksheet Functions | |||
Clear Checkboxes | Excel Discussion (Misc queries) | |||
How do I clear all Checkboxes on a worksheet on open | Excel Programming |