View Single Post
  #1   Report Post  
 
Posts: n/a
Default iterating checkboxes

I've got a few checkboxes in a sheet, "CheckBox1" through "CheckBox3".

I can do this:

c = CheckBox1.Value
etc.

But how would I iterate over them? Like, if I could do this:

c = CheckBox(1).Value

Things like this don't work:

c = ActiveSheet.Shapes("CheckBox1").Value