See Also Example
Used to perform a logical equivalence on two expressions.
result = expr1 Eqv expr2
If either expression is a Null When neither expression is a Null, result is determined according to the following table:, result is also a Null.
If expr1 And expr2 The result
is is is
True True True
True False False
False True False
False False True
The Eqv operator performs a bit-wise comparison of identically positioned bits in two numeric expressions and sets the corresponding bit in result according to the following truth table:
If bit in And bit in The result
expr1 is expr2 is is
0 0 1
0 1 0
1 0 0
1 1 1
Eqv Operator Example
The example displays a message that depends on the value of variables A, B, and C, assuming that no variable is a Null. If A = 10, B = 8, and C = 6, both expressions evaluate True. As a result, the Eqv expression also evaluates True. To try this example, paste the code into the Declarations section of a form. Then press F5 and click the form.
Sub Form_Click ()
Dim A, B, C, Msg ' Declare variables.
A = 10: B = 8: C = 6 ' Assign values.
If A > B Eqv B > C Then ' Evaluate expressions.
Msg = "Both expressions are True or both are False."
Msg = "One expression is True and one is False."
MsgBox Msg ' Display results.