Check boxes

[Ross]

I have a form I have created a sheet in an excel 2000 workbook that will
print out on an 8.5 X 11 paper the
top half of the form -- the part I want to fill in -- is an exact duplicate
of the bottom half and I want the bottom half to be fill in as the top half
is, automatically. I know how to do this with cells in the spreadsheet, but
there are about 50 check boxes in each half as well and I cannot figure out
how to make
say checkbox 29 in the lower half, which is the counterpart of checkbox6 in
the upper half become checked when I click on checkbox 6. I know there must
be an easy way to do this. right? Thanks in advance for any help

 

[Guest]

In the click event for the first checkbox place the following code:

Change the Checkbox names were applicable

Private Sub CheckBox1_Click()

Me.CheckBox2.Value = Me.CheckBox1.Value

End Sub

 

[Ross]

Thanks, but what and where is the "click event"?

In the click event for the first checkbox place the following code:

Change the Checkbox names were applicable

Private Sub CheckBox1_Click()

Me.CheckBox2.Value = Me.CheckBox1.Value

End Sub

 

[Ross]

Never mind, I figured it out -- right click, view code.
Thanx
Ross