What is the equivalent of logical negation/not operator

Question

I've to execute a piece of code written in Visual Basic for Applications (VBA) when the excel cell is not empty. I've written below piece of code so far:

Public Sub BindTitles(ByVal cell As Range)
    If IsEmpty(cell.Value) Then
        Application.EnableEvents = False
        'other code
    End If
End Sub

I want to invert the logical condition present in If statement. In C#, I use exclamation operator ! but when I put it in If block it gives below error:

Compile error:

Invalid or unqualified reference

You can use the `NOT` Operator: https://learn.microsoft.com/en-gb/dotnet/visual-basic/language-reference/operators/not-operator — sporc, Feb 09 '18 at 07:30
@KostasK. do you mind adding an answer so that I can close this thread? — RBT, Feb 25 '18 at 06:35

score 1 · Accepted Answer · edited Feb 25 '18 at 07:58

1

The logical negation ! operator in VBA is Not:

If Not IsEmpty(cell.Value) Then '...

edited Feb 25 '18 at 07:58

RBT

24,161
21
159
240

answered Feb 25 '18 at 07:54

Kostas K.

8,293
2
22
28

What is the equivalent of logical negation/not operator

1 Answers1