| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping through checkboxes
I have the line of code
Sheets(1).OLEObjects("CheckBox1").Object.Value = True that works great, but how do I loop through all the checkboxes in my sheet with something like this For Each cb In Sheets(1).OLEObjects.CheckBoxes Sheets(1).OLEObjects(cb.Name).Object.Value = True I get a runtime error 430 Object doesn't support this property or method. How do I loop through the checkboxes? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looping through checkboxes | Excel Programming | |||
| Looping Checkboxes in Worksheet | Excel Programming | |||
| Looping through a group of checkboxes | Excel Programming | |||
| Looping Checkboxes on Worksheet | Excel Programming | |||
| Checkboxes to spreadsheet using a looping macro | Excel Programming | |||
Threaded Mode
