I have a section of code which i must be missing something on. I have 7 activex checkboxes on a sheet called Datasheets which are grouped together for easy of moving them around. I would like to run a loop to test their state but I get an error "Object doesnt support this propert or method" I have tried Me!thischkbox instead but got an "Invalid use error"
For i = 1 To 7
thischkbox = "Checkbox" & i
If Sheets("Datasheet").thischkbox = True Then
MsgBox ("Checked") 'Code here for when box IS CHECKED
MsgBox ("UnChecked") 'Code here for when box IS NOT CHECKED