Creating "grouped" checkboxes

[aeshower]

Hello all,

Is it possible to create a group of checkboxes wher
checking/unchecking the top box, the "parent," would default the res
of the group, the "children?"

It is also required that the "children" can change their stat
independently from the "parent" if they are individuall
checked/unchecked.

Finally, is there a way to modify the functionality of the checkbox?
The desired functionality is to have certain cells in the linkedcel
row to become bold once the checkbox is checked, and unbolded once th
checkbox is unchecked. This functionality is only to be performed b
the children.

Thank you for your consideration,
Aaro

 

[Excelenator]

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
-------------------

 

[aeshower]

Thank you Excelenator,

However, this problem requires that dynamically added checkboxes
possess this functionality and I have no idea on how to automatically
add our method to newly ceated checkboxes.

Thanks again,
Aaron