View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jkrons jkrons is offline
external usenet poster
 
Posts: 19
Default 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?