Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
mulitple checkboxes - changing value of all of them at once
Hello,
I have mulitple checkbox controls (selected from the "control" toolbar) on one worksheet. I would like to set the state of each checkbox to unchecked all at once. I have figured out how to select all the checkboxes at one time using: ActiveSheet.OLEObjects.Select But I cannot figure out how to change the value of all of them to "false". I have tried, with no luck: Selection.Value = false Selection.oleobjects.Value = false Selection.oleobjects.object.Value = false etc etc Anyone how to do this? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mulitple value lookup | Excel Worksheet Functions | |||
Changing mulitple tab names | Excel Worksheet Functions | |||
Mulitple formulas | Excel Discussion (Misc queries) | |||
mulitple criteria | Excel Discussion (Misc queries) | |||
Changes to Mulitple Worksheets | Excel Worksheet Functions |