Excel VBA Opposite Boolean - Xtreme Visual Basic Talk

02-03-2010, 07:28 PM

Josh Hazel Josh Hazel is offline

Senior Contributor

Join Date: May 2008

Posts: 805

Excel VBA Opposite Boolean

Just trying to learn new tricks...

If i want to get the opposite of a number value I just stick a "-" negative symbol in front of the variable ... can i do something like that for a boolean?

I just thought it would be cool to be like blnValue = -(blnValue) rather than an if/then statement to check its value and set its new value... I could create a function, but maybe there is something already built in?

__________________
Josh

If Google = NoHelp Then PostHere = True

02-03-2010, 08:58 PM

Kluz

Sapience.Aquire

Super Moderator
* Expert *

Join Date: Oct 2003

Location: Lake Bluff, Ill., U.S.

Posts: 3,307

The NOT keyword will reverse the value of a boolean:

Code:

Dim x As Boolean
x = True
x = Not x
Msgbox x

__________________
No the other right mouse click

02-03-2010, 10:10 PM

Josh Hazel Josh Hazel is offline

Senior Contributor

Join Date: May 2008

Posts: 805

Wow, your right ... i thought there must be an ez way for that =p

__________________
Josh

If Google = NoHelp Then PostHere = True

Posting Rules

You may not post new threads

You may not post replies

You may not post attachments

You may not edit your posts

BB code is On

Smilies are On

[IMG] code is Off

HTML code is Off

Forum Rules