VBA If..Not (Logical Operator): Explained with 2 Examples

Purpose of VBA If Not – Logical operator

Just like the VBA “And” and “Or” operators, the “Not” is a logical operator that we use in the If..Statement.

• The code inside If..And execute as all conditions are True.
• In case of If..Or, if any of the given conditions is True, the code inside If executes.
• The Code executes in the If..Not case, if a given condition is False.
• Basically, Not operator negates the given condition. It is used to reverse the result of a condition or expression.
• The examples below should make it clearer.

An example of Not operator

See the following example and its output:

Code with If..Not:

Result:

If we omit “Not” in the If..then statement:

If x = 10 Then

Code in the If statement executes.

As we used “Not” in our program, it negated the result – so the Else code executed.

Using Excel Cell to demonstrate Not operator further

Let us use the if..Not operator with Excel cell.

We will set the cell interior color based on the condition with the Not operator.

If the current color of the A1 cell is Red, the C3 cell will be set to Green

If not Red, it should be set to Yellow.

See the code and output below:

Result:

As the color of the A1 cell is Red (3), and it negates the “Not” condition, so Else part was executed and it made the color of C3 cell green.