Hello,

I have Check Boxes (from the Control Toobox toolbar) in my worksheet. Some
of these are linked to cells so that I can write IF statements to see the
status of True or False.

My problem is that when the users click the Clear Form command button, the
tick marks are cleared from all check boxes, except for those that are linked
to a cell. Those ones have the grayed out ticked mark, even though the
Triple State property is False. Here is the part of the code that clears the
check boxes:

'Clear check boxes
With ActiveSheet
For Each Ctrl In .OLEObjects
If TypeName(Ctrl.Object) = "CheckBox" Then
Ctrl.Object.Value = False
End If
Next Ctrl
End With


Thanks.