This code will have Checkbox1 act as the "parent" to the Checkboxe
2-5.


Code
-------------------
Private Sub CheckBox1_Change()
CheckBox2.Value = -CheckBox1.Value
CheckBox3.Value = -CheckBox1.Value
CheckBox4.Value = -CheckBox1.Value
CheckBox5.Value = -CheckBox1.Value
End Su
-------------------

--
Excelenato

-----------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...fo&userid=3676
View this thread: http://www.excelforum.com/showthread.php?threadid=57418