Check Boxes

[Ross]

I created a form in a sheet of an Excell 2000 workbook that will print out
on an 8.5 X 11 paper. The top half of the form -- the part filled in
manually is an exact duplicate of the bottom half. I want the bottom half
to fill in automatically as the top half is filled in manually. I know how
to do this with cells in the spreadsheet, but there are various check
boxes -- roughly 50 in each half-- as well and I cannot figure out how to
make say checkbox 88 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]

I think this was answered in your other post, However:

In the click event of the check boxes in the upper form you place code that
makes the corresponding checkbox in the lower form equal to the top checkbox.

Private Sub Checkbox1_Click()
If Checkbox1.Value = True Then
Checkbox51.Value = True
Else
Checkbox51.Value = False
End If
End Sub

To add the code, right click the checkbox, then click View Code. This opens
the code module for the control. You should see the first and last lines of
the click event sub. Just fill in the middle.

 

[Dave Peterson]

You have active threads at your other posts.

I created a form in a sheet of an Excell 2000 workbook that will print out
on an 8.5 X 11 paper. The top half of the form -- the part filled in
manually is an exact duplicate of the bottom half. I want the bottom half
to fill in automatically as the top half is filled in manually. I know how
to do this with cells in the spreadsheet, but there are various check
boxes -- roughly 50 in each half-- as well and I cannot figure out how to
make say checkbox 88 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