200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Hi everyone!
I'm trying to write a simple macro but cant figure out how to get the "not equals" to sign to work.
Here is a simple example of what I'm trying to do:
Sub not_equals()
If Range("A1").Value Is Not "Yes" Then
MsgBox "You must input Yes."
End If
End SubI also tried like this:
Sub not_equals()
If Range("A1").Value != "Yes" Then
MsgBox "You must input Yes."
End If
End SubEach one gives me errors... I'm sure it's something simple but please can anyone help?
Instead of Is Not or != you need to use <>
<> is the way to say "not equals to" in Excel vba.
So try this:
Sub not_equals()
If Range("A1").Value <> "Yes" Then
MsgBox "You must input Yes."
End If
End Sub