Vba I About the Tutorial



Download 1.46 Mb.
View original pdf
Page31/35
Date16.12.2020
Size1.46 Mb.
#54903
1   ...   27   28   29   30   31   32   33   34   35
vba tutorial
The Comparison Operators
There are following comparison operators supported by VBA. Assume variable A holds 10 and variable B holds 20, then -
Operator
Description
Example
== Checks if the value of the two operands are equal or not. If yes then the condition is true. AB) is False.
<> Checks if the value of the two operands are equal or not. If the values are not equal then the condition is true. AB) is True.
> Checks if the value of the left operand is greater than the value of the right operand. If yes then the condition is true. AB) is False.
<
Checks if the value of the left operand is less than the value of the right operand
I
f yes
,
then the condition is true.
(A < B) is
True.
>= Checks if the value of the left operand is greater than or equal to the value of the right operand. If yes then the condition is true. AB) is False.
<=
Checks if the value of the left operand is less than or equal to the value of the right operand
. I
f yes
,
then the condition is true.
(A <= B) is
True.

Download 1.46 Mb.

Share with your friends:
1   ...   27   28   29   30   31   32   33   34   35




The database is protected by copyright ©ininet.org 2024
send message

    Main page