Previous Document Next Document

Understanding automation : How is automation coding structured? : Using Boolean comparison and assignment

Using Boolean comparison and assignment

In Microsoft Visual Basic (VB), Boolean comparison and Boolean assignment are both performed by using a single equals sign ( = ):

If a = b Then c = d

By contrast, many other languages use a double equals sign for Boolean comparison and a single equals sign for Boolean assignment:

if( a == b ) c = d;

The following code, which is valid in C, C++, Java, and JavaScript, is invalid in VBA:

if( ( result = fooBar( ) ) == true )

The preceding example would be written in VBA as the following:

result = fooBar( )
If result = True Then

For other Boolean comparisons, VBA uses the same operators as other languages (except for the operators for “is equal to” and “is not equal to”). All the Boolean-comparison operators are provided in the following table.

VBA operator
C-style operator
Is equal to
Is not equal to
Is greater than
Is less than
Is greater than or equal to
Is less than or equal to

The result of using a Boolean operator is always either True or False.

Previous Document Next Document Back to Top

Copyright 2013 Corel Corporation. All rights reserved.