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

Hi Rusty,

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

---
Regards,
Norman



"Rusty" wrote in message
...
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

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" wrote in message
...
Hi Rusty,

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

---
Regards,
Norman



"Rusty" wrote in message
...
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

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


---
Regards,
Norman



"Rusty" wrote in message
...
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" wrote in message
...
Hi Rusty,

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

---
Regards,
Norman



"Rusty" wrote in message
...
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

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" wrote in message
...
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


---
Regards,
Norman



"Rusty" wrote in message
...
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" wrote in message
...
Hi Rusty,

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

---
Regards,
Norman



"Rusty" wrote in message
...
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

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.

---
Regards,
Norman



"Rusty" wrote in message
...
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" wrote in message
...
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


---
Regards,
Norman



"Rusty" wrote in message
...
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" wrote in message
...
Hi Rusty,

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

---
Regards,
Norman



"Rusty" wrote in message
...
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