Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Checkboxes to enable/disable vb
I'm running a macro and trying to have parts of the code run or not run
depending on whether various checkboxes are checked. The checkboxes are from the Forms toolbar, and they all reference cells in column L Basically this is what I have.. If Sheet1.Cells(12, 7).Value = "TRUE" Then (I've tried of variations of referencing the cell) ....code... and just for good measure in the Else portion I've put Sheet1.Range("E7") = [L7].Value And of course L7 reads TRUE when I run the macro. Thanks in advance Paul Salama |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enable/Disable Macro Pop-Up | Excel Discussion (Misc queries) | |||
Enable/Disable Macros Pop-Up | Excel Discussion (Misc queries) | |||
Enable/Disable Macros | Excel Discussion (Misc queries) | |||
How to enable/disable a button. | Excel Programming | |||
Enable/Disable Macros | Excel Programming |