CheckBox Checked Function

[grayday]

I have two sheets in my workbook, one for data entry, and the second i
where the data is filled in depending on what is entered on th
first/data entry page. When completed, the user will never even se
the second page, it is being faxed out to customers.

I have four checkboxes on the first page. They each have fou
corresponding checkboxes on the second page. I need to make sure tha
if someone checks checkbox A on the first page, the correspondin
checkbox A gets automatically checked on the second page. I've looke
around, and something simialr to this would probably work:

Private Sub CheckBox1_Click()
With Worksheets("Sheet5")
If CheckBox1.Value Then
.Range("B4").Value = "Y"
Else
.Range("B4").Value = "N"
End If
End With
End Sub

Except of course, instead of Y or N, it would have to be
IF CheckBox1.Value Then
->click checkbox5 on page two<-

I can't get it to work though. Also, when I used the form toolbar t
create my checkboxes, my checkboxes didn't go into a specific cell
they're just kind of free floating. The problem is that I can't refe
to any specific cell as containing a checkbox.

There's got to be an easy way to say "if this checkbox is clicked, mak
this other checkbox on another page also get clicked" without having t
link cells. Or if someone can explain how to insert checkboxes i
specific cells.

Thanks in advance for any help

 

[Karl]

Private Sub CheckBox1_Click()
Sheet2.CheckBox1.Value = Sheet1.CheckBox1.Value
End Sub

Private Sub CheckBox2_Click()
Sheet2.CheckBox2.Value = Sheet1.CheckBox2.Value
End Sub

ETC

 

[grayday]

Bingo. Exactly what I needed.

Thanks Karl

 

[Karl]

no probs thanks for the feedback