check box

[Rusty]

Can two check box's be linked so if one is checked, the other will not be? I need them to toggle back and forth between "repair and replace"
Thank You

 

[Norman Jones]

Hi Rusty,

Why not use option buttons which should do what you want?

---
Regards,
Norman



Can two check box's be linked so if one is checked, the other will not be? I
need them to toggle back and forth between "repair and replace"
Thank You

 

[Rusty]

I'm trying to copy a bank form. So I can make changes and print. I want to
print out with the checks mark's.
I don't even need a name for the check box, it will be in the top row
"repair replace"

 

[Norman Jones]

Hi Rusty,

One way:

With two Control Toolbox checkboxes, in the worksheet's code module paste
the following:


Private Sub CheckBox1_Click()
CheckBox2.Value = Not (CheckBox1.Value)
End Sub

Private Sub CheckBox2_Click()
CheckBox1.Value = Not (CheckBox2.Value)
End Sub

 

[Rusty]

Can this be done all at once or do I have to do it 2 box's at a time.In
other words I have repair and replace on top, and 2 check box's in each row
down to about 50 or so.

 

[Norman Jones]

Hi Rusty,

You need to set the mutually dependent relationship for each pair of
checkboxes. So, whilst you can reduce the wokload by a sensible naming
strategy and by using the first pair of subs as a template for the
subsequent pairs, your typing fingers are still going to be busy.