link cells to a vb check box

[jmz82]

What I want to do is put in a check box that when checked cell A2 has the same thing as A1. I'm not great at vb but I tried something like this: If checkbox1 = true then a2 = a1. I'm not quite sure how to reference the cells or say the last part.

 

[decklun]

try

If checkbox1.Value = True Then
ActiveSheet.Range("A2").Value = ActiveSheet.Range("A1").Value
End If

 

[jmz82]

That worked perfect, one more question.....How would I do a and statement. for instance if checkbox1 is checked a2 = a1 and a4 = a3. Thank you