Clearing specific checkboxes

[paster]

Ok, first post and relative beginner. I am in the process of setting up a schedule type worksheet. In cell A1 I would enter the task. In cell A2 I will have three checkboxes related to this task, with each department checking off their completed portion for the said task. Once the final checkbox is checked off, the job is considered complete.

Now, if the task in cell A1 is cleared, is it possible to have this action also clear all the related checkboxes in A2? If this is not possible is it possible to have a form button in cell A2 that would clear the checkboxes in that cell only? I do not want to clear all the checkboxes on the page as there will be other tasks and checkboxes.

Hope I am clear enough and thank you for any help anyone can provide.

 

[macleanb]

Something like this on the worksheet:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" And Target = "" Then

ActiveSheet.OLEObjects("CheckBox1").Object.Value = 0

End If

End Sub

 

[macleanb]

Something like this on the worksheet:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" And Target = "" Then

ActiveSheet.OLEObjects("CheckBox1").Object.Value = 0

End If

End Sub