| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checking and Unchecking CheckBoxes in code
I have 7 checkbox and 2 option buttons. One of the option buttons unchecks
all the checkboxes and the other one checks all the options buttons. In Excel 2003 I was able to use somthing like this to do that: For Each ctl In InputForm2.Controls If TypeName(ctl) = "CheckBox" Then If ctl.Value = True Then ctl.Value = False ElseIf ctl.Value = False Then ctl.Value = True End If End If Next ctl This don't work in Excel 2007. Any ideas Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need code for hiding/unhiding sheets using checkboxes | Excel Worksheet Functions | |||
| Unchecking radio button | Excel Discussion (Misc queries) | |||
| Unchecking check boxes on exit | Excel Discussion (Misc queries) | |||
| Color Code Date Checking | Excel Worksheet Functions | |||
| PivotTable - Unchecking and re-checking data fields | Excel Discussion (Misc queries) | |||
Hybrid Mode
