hi
try this.....
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
Range("C32").Value = "Hello"
Range("C33").Value = "Goodbye"
Else
Range("C32").Value = ""
Range("C33").Value = ""
End If
End Sub

regards
FSt1
"Corey" wrote:

I am having difficulty assigning a small macro to a checkbox i have on a sheet.

I right click on the checkbox to assign a macro and have this :

Sub checkbox10_click()

End Sub

I simply want a basic ocurance such as:

If the checkbox is TICKED then Range("C32").value = "Hello" and Range("C33").value = "Goodbye"

Else if the Checkbox is NOT TICKED then both C32 and C33 to be empty (="")


I cannot get the correct syntax for the checkbox??

Corey....