Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing a checkbox
I have been playing around with controls on excel 2007 and am getting
frustrated ofver something I am sure is very simple...I simply want to perform an action when a checkbox = true. I have the following code: Sub CheckBox1_Click() If CheckBox1 = True Then ThisWorkbook.Sheets("Sheet1").Cells(1, 1) = "A" End If End Sub For some reason this code does not recognize when the checkbox is true or not. can someone point me in the right direction? Thanks! Chad |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing Checkbox Names | Excel Worksheet Functions | |||
link a checkbox in a sheet to a checkbox on a userform? | Excel Programming | |||
How do I link one checkbox to update another checkbox? | Excel Programming | |||
checkbox on form reset from checkbox on sheet | Excel Programming | |||
referencing a checkbox cell address in a worksheet | Excel Programming |