# VBA Comparison Operators

VBA comparison operators are used to compare values in VBA and Macros for Excel.

## List of VBA Comparison Operators

Comparison Operator |
Meaning |
---|---|

< |
A < B - Checks if A is LESS THAN B. |

> |
A > B - Checks if A is GREATER THAN B. |

<= |
A <= B - Checks if A is less than or equal to B. |

>= |
A >= B - Checks if A is greater than or equal to B. |

= |
A = B - Checks if A is equal to B. Note that a single equal sign is also used to assign a value to a variable when it is not being used in the context of a comparison. |

<> |
A <> B - Checks if A is NOT equal to B. |

## Comparison Operator Examples

Each example uses an IF statement to compare the values A and B and it will then output a message depending on the result of the comparison.

The part to pay attention to comes between the **If** and **Then** section of the code.

### A < B

If A is less than B.

```
If A < B Then MsgBox "Hi!" Else MsgBox "Bye!"
```

### A > B

If A is greater than B.

```
If A > B Then MsgBox "Hi!" Else MsgBox "Bye!"
```

### A <= B

If A is less than or equal to B.

```
If A <= B Then MsgBox "Hi!" Else MsgBox "Bye!"
```

### A >= B

If A is greater than or equal to B.

```
If A >= B Then MsgBox "Hi!" Else MsgBox "Bye!"
```

### A = B

If A is equal to B.

```
If A = B Then MsgBox "Hi!" Else MsgBox "Bye!"
```

### A <> B

If A is not equal to B.

```
If A <> B Then MsgBox "Hi!" Else MsgBox "Bye!"
```

## Notes

Comparison operators are pretty straightforward but it does take a little time to get used to using them.

Bookmark this guide for future reference.

Download the file attached to this tutorial for the VBA code in Excel.

Tutorial: Logical comparison operators allow you to compare values in Excel to see if they are equal...

Tutorial: IF statements allow you to make decisions in your Macros and VBA in Excel. An IF statement...

Tutorial: Logical operators in VBA allow you to make decisions when certain conditions are met. They...

Tutorial: The SUMIF function allows you to sum values based on a single criteria. This function wor...

Tutorial: How to use parentheses in Excel in order to create more powerful formulas and functions. S...

Tutorial: The SUMIFS function allows you to sum values that meet multiple criteria across multiple ...