Using Checkboxes to enable/disable vb

paul.salama@gmail.com · 06-14-2006, 12:00 PM

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

**Bearacade** · 06-14-2006, 12:50 PM

I am not certain if this will help with your problem.

But I created a blank **** and a checkbox and put the following code in it:

Sub test()
If CheckBox1.Value = "True" Then
MsgBox ("True")
Else
If CheckBox1.Value = "False" Then
MsgBox ("False")
End If
End If
End Sub

It also works if you are referencing a cell's value.

Dave Peterson · 06-14-2006, 01:00 PM

Try removing the double quotes:

If Sheet1.Cells(12, 7).Value = True Then

paul.salama@gmail.com 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

Paul · 06-14-2006, 01:45 PM

Thanks a lot. it seems that the capitalization made a difference. so
matching on "True" worked, but not "TRUE"... Even though the actual
text is capitalized.

so this is what worked:
If Sheet1.[L7].Value = "True" Then
....code...

Thanks again.

Paul

Dave Peterson · 06-14-2006, 02:10 PM

Did removing the double quotes work when you tried it?

Paul wrote:
>
> Thanks a lot. it seems that the capitalization made a difference. so
> matching on "True" worked, but not "TRUE"... Even though the actual
> text is capitalized.
>
> so this is what worked:
> If Sheet1.[L7].Value = "True" Then
> ...code...
>
> Thanks again.
>
> Paul

--

Dave Peterson

Paul · 06-15-2006, 12:15 PM

Oddly enough it didn't

Dave Peterson wrote:
> Did removing the double quotes work when you tried it?
>
>
> Paul wrote:
> >
> > Thanks a lot. it seems that the capitalization made a difference. so
> > matching on "True" worked, but not "TRUE"... Even though the actual
> > text is capitalized.
> >
> > so this is what worked:
> > If Sheet1.[L7].Value = "True" Then
> > ...code...
> >
> > Thanks again.
> >
> > Paul
>
> --
>
> Dave Peterson

Dave Peterson · 06-15-2006, 12:45 PM

It worked ok for me when I tested.

Paul wrote:
>
> Oddly enough it didn't
>
> Dave Peterson wrote:
> > Did removing the double quotes work when you tried it?
> >
> >
> > Paul wrote:
> > >
> > > Thanks a lot. it seems that the capitalization made a difference. so
> > > matching on "True" worked, but not "TRUE"... Even though the actual
> > > text is capitalized.
> > >
> > > so this is what worked:
> > > If Sheet1.[L7].Value = "True" Then
> > > ...code...
> > >
> > > Thanks again.
> > >
> > > Paul
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson