Thread: check box
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Rusty[_3_] Rusty[_3_] is offline
external usenet poster
 
Posts: 9
Default check box

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