Vba
VBA Controls: VBA Form Control & ActiveX Controls in Excel
Creating VBA Form/GUI controls in Excel GUI is the acronym for Graphical User Interface. The GUI...
These are operators that are used to compare values. Comparison operators include equal to, less than, greater than and not equal to
Comparison operators are used to compare values for validation purposes. Let's say you are developing a simple point of sale application. In this application, you want to validate the values entered before you post. In such cases, you can use comparison operators. This operator will check against the negative numbers or to ensure that the amount paid does not exceed the billed amount. Comparison operators come in handy in such situations.
The following table lists the comparison operators defined in VBA.
Operator | Description |
---|---|
= | Equal: checks if two values are equal. It is also used as an assignment operator |
< | Less than: This operator is used to subtract numbers |
> | Greater than: This operator is used to multiply numbers |
<> | Not equal to: This operator is used to divide numbers |
<= | Less than or equal to: |
>= | Greater than or equal to: |
The following table shows Excel VBA Comparison Operators with examples and output.
S/N | Operator | Example | Output |
---|---|---|---|
1 | = | If x = z Then | Returns true if they are equal, else it returns false |
2 | < | If x < z Then | Returns true if x is less than z, else it returns false |
3 | > | If x > z Then | Returns true if x is greater than z, else it returns false |
4 | <> | If x <> z Then | Returns true if they are not equal, else it returns false |
5 | <= | If x <= z Then | Returns true if x is less than or equal to z, else it returns false |
6 | >= | If x >= Then | Returns true if x is greater than z, else it returns false |
Equal Comparison Operator
If 2 = 1 Then MsgBox "True", vbOKOnly, "Equal Operator" Else MsgBox "False", vbOKOnly, "Equal Operator" End If
HERE,
Executing the above code gives the following results
Creating VBA Form/GUI controls in Excel GUI is the acronym for Graphical User Interface. The GUI...
Download PDF 1) Explain what is VBA or Visual Basic for Applications? VBA stands for Visual Basic...
What is VBA Array? An array is defined as a memory location capable of storing more than one...
This Excel VBA tutorial for beginners covers in-depth lessons to learn VBA Excel and VBA basics....
VBA Arithmetic Operators are used to perform arithmetic operations such as adding, subtracting,...
What is VBA Range? The VBA Range Object represents a cell or multiple cells in your Excel...