But he did not want them to toggle - he wanted them all true
or all false.

Chrissy.


"Heiko" wrote in message ...
Hello
This will toggle all Checkboxes in Frame frChecks:

Dim ctr As MSForms.CheckBox
For Each ctr In Me.frChecks.Controls
ctr.Value = Not ctr.Value
Next ctr

Heiko
:-)
"Shunt" wrote:

Hiya

I have a Userform which contains a frame.
This frame contains ten or so CheckBoxes.

I am looking for a macro or function by which I can make
all the boxes checked or unchecked.

I was hoping I could reference to the frame's members
rather than referring to each checkbox in turn.

Is this possible?

I would apprecaite any help (even an answer saying its not
possible!)