Check boxes

  • Thread starter Thread starter Ross
  • Start date Start date
R

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
 
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
 
Thanks, but what and where is the "click event"?
Kevin B said:
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
Click to expand...
 
Back
Top