*Resolved* Checkbox VBA Syntax?

[TheRobster]

I've got a simple piece of code in Excel VBA which is:

Sub CheckBox1_Click()
If CheckBox1.Value = True Then
    Range("A1").Value = 1
Else
    Range("A1").Value = 0
End If

End Sub

which is supposed to make 1 or 0 appear in cell A1 depending on whether or not a checkbox is ticked. However all I get is the error message 'Runtime error 424. Object required'.

I don't know what this means or why the code doesn't work and I can't find anything in Excel Help which explains what's wrong!

Anyone help?

Cheers
-Rob