What is the equivalent of "!=" in Excel VBA? What is the equivalent of "!=" in Excel VBA? vba vba

What is the equivalent of "!=" in Excel VBA?


Because the inequality operator in VBA is <>

If strTest <> "" Then    .....

the operator != is used in C#, C++.


In VBA, the != operator is the Not operator, like this:

If Not strTest = "" Then ...


Just a note. If you want to compare a string with "" ,in your case, use

If LEN(str) > 0 Then

or even just

If LEN(str) Then

instead.