Not Operator
Negates an expression by inverting the bit values.
α‘ααα’αα₯α‘α
Result = Not Expression
Parameters:
Result: Any numeric variable that contains the result of the negation.
Expression1, Expression2: ααααα‘αααα α αͺαα€α α£αα α‘αααααααα αα α‘α’α αα₯ααααα, α αααααααͺ αααααα α¨ααααα αα.
When a Boolean expression is negated, the value True changes to False, and the value False changes to True.
In a bitwise negation each individual bit is inverted.
αααααααα:
Sub ExampleNot
Dim vA As Variant, vB As Variant, vC As Variant, vD As Variant
Dim vOut As Variant
vA = 10: vB = 8: vC = 6: vD = Null
vOut = Not vA ' Returns -11
vOut = Not(vC > vD) ' Returns -1
vOut = Not(vB > vA) ' Returns -1
vOut = Not(vA > vB) ' Returns 0
End Sub