Reply to thread

Message: [QUOTE="Joyce, post: 6414901"] 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. [/QUOTE]