The "Not" operator has very simple
function:
Not True = False
Not False = True
Before we continue,
I'll mention that you don't have to include
"Else" in the "If"
statement.
For example:
Dim Password As String
Password = InputBox("Please enter the password")
If (Password = "let me in") Then
MsgBox "The Password is correct!"
End If
If the password is correct, The code above
will display a message box with the text
"The Password is correct!".
Otherwise, the code will do nothing,
because there is no "Else".