| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Uncheck Forms Check box via code
Hello all. I have the following bit of code:
Sub Uncheck() For Each chbx In Worksheets("test").CheckBoxes chbx.Value = False Next End Sub I have workbooks with one checkbox on 100 sheets. How can I modify the above code to uncheck each checkbox on every sheet? Also, How could I modify it to check the box only on certain predetermined sheets? Thanks so much! -Steph |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check and uncheck macro | Excel Worksheet Functions | |||
| check or uncheck a check box based on a cell value | Excel Discussion (Misc queries) | |||
| Uncheck check boxes | Excel Discussion (Misc queries) | |||
| How do I check/uncheck ten or odd Checkboxes by click on one check | Excel Discussion (Misc queries) | |||
| Check / Uncheck Box | Setting up and Configuration of Excel | |||
![Steph[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
