Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning a Worksheet Name to a Cell | Excel Worksheet Functions | |||
Assigning checkbox to the cell | Excel Programming | |||
assigning worksheet variable | Excel Programming | |||
Assigning a macro to a worksheet (vs personal.xls) | Excel Programming | |||
Assigning click event to OleObjects checkbox | Excel Programming |