Single command to toggle a Boolean?

[Ed]

In Excel 2000 VBA, is there one single command to toggle a Boolean - that
is, in whatever state it's in, change it to the opposite? I know it can be
done with an If / Else - I was just wondering if there was a singe-line way
to do it.

Ed

[Bill Martin]

Ed wrote:
> In Excel 2000 VBA, is there one single command to toggle a Boolean - that
> is, in whatever state it's in, change it to the opposite? I know it can be
> done with an If / Else - I was just wondering if there was a singe-line way
> to do it.
>
> Ed
>
>

----------------

Dim Flag as Boolean
Flag = not(Flag)

Bill

[Chip Pearson]

Ed,

Use the Not operator. This will switch a boolean to its opposite.
E.g,

Dim Var As Boolean Dim Var As Boolean
Var = Not Var


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Ed" <ed_millis@NO_SPAM.yahoo.com> wrote in message
news:[email protected]...
> In Excel 2000 VBA, is there one single command to toggle a
> Boolean - that
> is, in whatever state it's in, change it to the opposite? I
> know it can be
> done with an If / Else - I was just wondering if there was a
> singe-line way
> to do it.
>
> Ed
>
>

[Chip Pearson]

I have no idea how I got two Dim statements in the code. The
code should have only one Dim Statement.

Dim Var As Boolean
Var = Not Var


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Chip Pearson" <[email protected]> wrote in message
news:[email protected]...
> Ed,
>
> Use the Not operator. This will switch a boolean to its
> opposite. E.g,
>
> Dim Var As Boolean Dim Var As Boolean
> Var = Not Var
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
>
> "Ed" <ed_millis@NO_SPAM.yahoo.com> wrote in message
> news:[email protected]...
>> In Excel 2000 VBA, is there one single command to toggle a
>> Boolean - that
>> is, in whatever state it's in, change it to the opposite? I
>> know it can be
>> done with an If / Else - I was just wondering if there was a
>> singe-line way
>> to do it.
>>
>> Ed
>>
>>
>
>

[Ed]

Thanks, Chip.

"Chip Pearson" <[email protected]> wrote in message
news:[email protected]...
> I have no idea how I got two Dim statements in the code. The
> code should have only one Dim Statement.
>
> Dim Var As Boolean
> Var = Not Var
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
>
> "Chip Pearson" <[email protected]> wrote in message
> news:[email protected]...
> > Ed,
> >
> > Use the Not operator. This will switch a boolean to its
> > opposite. E.g,
> >
> > Dim Var As Boolean Dim Var As Boolean
> > Var = Not Var
> >
> >
> > --
> > Cordially,
> > Chip Pearson
> > Microsoft MVP - Excel
> > Pearson Software Consulting, LLC
> > www.cpearson.com
> >
> >
> >
> > "Ed" <ed_millis@NO_SPAM.yahoo.com> wrote in message
> > news:[email protected]...
> >> In Excel 2000 VBA, is there one single command to toggle a
> >> Boolean - that
> >> is, in whatever state it's in, change it to the opposite? I
> >> know it can be
> >> done with an If / Else - I was just wondering if there was a
> >> singe-line way
> >> to do it.
> >>
> >> Ed
> >>
> >>
> >
> >
>
>

[Ed]

Thanks, Bill.

"Bill Martin" <[email protected]> wrote in message
news:[email protected]...
> Ed wrote:
> > In Excel 2000 VBA, is there one single command to toggle a Boolean -
that
> > is, in whatever state it's in, change it to the opposite? I know it can
be
> > done with an If / Else - I was just wondering if there was a singe-line
way
> > to do it.
> >
> > Ed
> >
> >
>
> ----------------
>
> Dim Flag as Boolean
> Flag = not(Flag)
>
> Bill

[wagnerlip]

14 years ago, but the issue still.
Excel VBA

A = 1
A = NOT A

A results in -2

A = NOT A

A results in +1, and keeps flipping between +1 and -2.
Why is that? Why not flips between 1 and 0 ?

I use

A = ABS(A-1) to flip between 1 and 0 faster, but thought NOT could do it too.

using XOR also gives me what I need,
A = A XOR 1
Flips between 1 and 0 nicely, but still using one extra argument than NOT.

[FDibbins]

14 years ago, but the issue still.
Excel VBA

A = 1
A = NOT A

A results in -2

A = NOT A

A results in +1, and keeps flipping between +1 and -2.
Why is that? Why not flips between 1 and 0 ?

I use

A = ABS(A-1) to flip between 1 and 0 faster, but thought NOT could do it too.

using XOR also gives me what I need,
A = A XOR 1
Flips between 1 and 0 nicely, but still using one extra argument than NOT.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread