{"id":96527,"date":"2021-06-21T09:00:31","date_gmt":"2021-06-21T03:30:31","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=96527"},"modified":"2021-06-06T14:18:46","modified_gmt":"2021-06-06T08:48:46","slug":"vba-comparison-operators","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/vba-comparison-operators\/","title":{"rendered":"VBA Comparison Operators"},"content":{"rendered":"

Comparison operators are the operators that are used to compare values. Some of the comparison operators are equal to (=), less than (<), greater than(>) and not equal to(<>).<\/span><\/p>\n

The user mostly uses comparison operators to compare the values for the purpose of validation. Comparison operators come in handy in situations such as where you want to compare the total amount you invested vs the amount you had in your hand.\u00a0<\/span><\/p>\n

VBA Comparison Operators<\/h3>\n\n\n\n\n\n\n\n\n\n
Function<\/b><\/td>\nOperator<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
<<\/span><\/td>\nLess than<\/span><\/td>\nThis operator returns true if the LHS value is lesser than the RHS value or else it returns false.<\/span><\/td>\n<\/tr>\n
><\/span><\/td>\nGreater than<\/span><\/td>\nThis operator returns true if the LHS value is greater than the RHS value or else it returns false.<\/span><\/td>\n<\/tr>\n
<=<\/span><\/td>\nLesser than or Equal To<\/span><\/td>\nThis operator returns true if the LHS value is lesser than or equal to the RHS value or else it returns false.<\/span><\/td>\n<\/tr>\n
>=<\/span><\/td>\nGreater than or Equal To<\/span><\/td>\nThis operator returns true if the LHS value is greater than or equal to the RHS value or else it returns false.<\/span><\/td>\n<\/tr>\n
=<\/span><\/td>\nEqual To<\/span><\/td>\nThis operator returns true if the two values are equal or else it returns false.<\/span><\/td>\n<\/tr>\n
<><\/span><\/td>\nNot Equal To<\/span><\/td>\nThis operator returns true if the two values are not equal to each other or else it returns false.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Example of VBA Comparison Operators<\/h3>\n

To perform comparison operations, follow the steps:<\/span><\/p>\n

1: Open an excel workbook and save it as an excel macro-enabled workbook.\u00a0<\/span><\/p>\n

2: <\/span>\u00a0<\/b>Add a button using macros.\u00a0<\/span><\/p>\n

In order to create a macro,\u00a0<\/span><\/p>\n