Like this:
Although if you use forms controls, you can use:![]()
For i = 1 To 2 If Sheet1.Shapes("Checkbox" & i).OLEFormat.Object.Object.Value = True Then MsgBox ("True") End If Next i
![]()
Dim cbx As CheckBox For Each cbx In Sheet1.CheckBoxes MsgBox cbx.Name & vbCr & cbx.Value Next cbx
Bookmarks