Try putting true and false in quotes. Like "True"
and "False". Remember it's case sensitive.


-----Original Message-----
How do you make if True, Display the value of Sheet2
Cell B4? Below will not work.

Private Sub CheckBox1_Click()
With CheckBox1
If CheckBox1.Value = True Then ActiveSheet.Range
("A2").Value = "Sheet2!$B$4"
If CheckBox1.Value = False Then ActiveSheet.Range
("A2") = ""
End With
End Sub

Thank you
.