read more is not equal, then only it will return TRUE or else FALSE.įor example, if you say 10 10, it will return FALSE because 10 is equal to 10. The equals to operator, “=,” is the most commonly used logical test. If the supplied logical test in excel Logical Test In Excel A logical test in Excel results in an analytical output, either true or false.
![visual basic script visual basic script](http://3.bp.blogspot.com/_UZtvkcbidps/TA1-dFTP4uI/AAAAAAAAATM/RuA39vmqPqM/w1200-h630-p-k-no-nu/DateName-vbs-Security-Warning.jpg)
On the other side, “Not Equal” works in the opposite direction. For example, if you say 10 = 10, it will return TRUE or else FALSE. Equal to operator returns TRUE if the supplied test is satisfied is not, it will return FALSE. VBA Not equal works exactly opposite to the logic of equal to operator. If both these operators combined, then it becomes not equal symbol i.e., “.” How Not Equal to Works in Excel VBA? “NOT EQUAL” in VBA is represented by the combination of greater than and less than symbols. Similarly, using the Inequality test also we can do some kind of operation. Generally, we say if something is equal to other thing or not, if it is equal, performs some kind of task if not different task.
![visual basic script visual basic script](https://1.bp.blogspot.com/-tPlSvau3csM/Xtow1GCqlCI/AAAAAAAAQJI/zn_dnJmt7W0B5DvqzvZarLcwkxY34KMyQCLcBGAsYHQ/w1200-h630-p-k-no-nu/Add%2Ba%2Bheading%2B%2810%29.png)
The inequality test is nothing but not an equal test. Usually, we do a logical test “whether something is equal to other things or not.” In some cases, we need to do the “inequality” test as well. Not Equal is an operator in VBA which can also be termed as a negation operator, it is a logical function so the output returned by this function is either true or false, we know that equal operator is “=” this but not equal is “” in VBA so whatever the value we get from the equal operator we will get exact opposite value using Not Equal operator.