I'm trying to put together a simple (?) form using a Active X and legacy form controls - I have a situation where if a user selects Checkbox 1 (active X) then Checkbox 3 and Checkbox 4 are also selected, likewise if a user select Checkbox 3 then Checkbox 4 and 1 are selected and so on... in reverse, if any are deselected then the remaining boxes will be deselected.



At the moment I can complete the first part of the objective using the below, but not the deselection element.

Private Sub CheckBox1_Click()
CheckBox2.Value = True
End Sub

Can anyone advise