I'm trying to write an "IF" statement that checks the status of a check box,
then places text in certain cells accordingly (in Excel 2002). ("ELSE" clears
them.)

Private Sub CheckBox3_Click()
If CheckBox3.Value = True Then
MsgBox "True", , "checkbox3"
Range("D5").Select
ActiveCell.FormulaR1C1 = "check"
Range("E5").Select
ActiveCell.FormulaR1C1 = "box"
Range("F5").Select
ActiveCell.FormulaR1C1 = "testing"
Range("D5").Select
Else
MsgBox "False", , "checkbox3"
Range("D5").Select
ActiveCell.FormulaR1C1 = ""
Range("E5").Select
ActiveCell.FormulaR1C1 = ""
Range("F5").Select
ActiveCell.FormulaR1C1 = ""
Range("D5").Select
End If
End Sub

When I click the checkbox I get "Run-time error '424': Object required".
I've reviewed many of the "check box" posts, but can't get the info I need.
Please help!