View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 363
Default Assigning a Macro to Checkbox on a worksheet

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....