Thread
:
Using Checkboxes to enable/disable vb
View Single Post
#
3
Posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
Posts: 35,218
Using Checkboxes to enable/disable vb
Try removing the double quotes:
If Sheet1.Cells(12, 7).Value = True Then
wrote:
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
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson