Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check All Check Boxes
Sorry, about this, but my head is sore from pounding on the desk....
Have a handful of check marks that I put on via the Forms Check Box and want to have a sub that will check/uncheck all of them. However, i can't even get the basics on this. What am i missing? I keep getting error messages no matter how I try to tweak...last error is "object required" Sub CheckAll_Houses() With ActiveSheet CheckBox18.Value = True CheckBox19.Value = True CheckBox20.Value = True CheckBox21.Value = True CheckBox22.Value = True End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked Check Boxes | Excel Discussion (Misc queries) | |||
Can one cell hold multiple check boxes (and then sort based off e. | Excel Discussion (Misc queries) | |||
why do check boxes move when printing excel spreadhseets | Excel Discussion (Misc queries) | |||
Selecting Check Boxes | Excel Discussion (Misc queries) | |||
How to align check boxes on an Excel sheet? | Excel Worksheet Functions |