Do controls dropped in a worksheet have the same properties as controls placed on UserForms?
They do if the control is from the Active-X controls and not from the Forms controls.
If your checkbox is from the Forms tool box, then you need to link the check box to a cell and test the cell value for true or false.
Assuming cell A1 is the linked cell . .
If Range("A1").Value = True then
'Code
End If
If your checkbox is an Active-X type, then something like:
If Me.CheckBox1.Value = True then
'code
End If
Bookmarks