Debugging a VBA If statement:

I have a compound if statement that should evaluate to True, but it doesn't. I want to find which part is evaluating to false.

The statement looks like:
If _
Something = something And _
A=X Or A=C And _
Etc.
End if

I'm using VBA for Excel. I also have notepad++.

Thanks in advance.

Question

Debugging a VBA If statement:

I have a compound if statement that should evaluate to True, but it doesn't. I want to find which part is evaluating to false.

The statement looks like: 
If _
  Something = something And _
  A=X Or A=C And _
  Etc.
End if

I'm using VBA for Excel. I also have notepad++.

Thanks in advance.

anonymous · Answer

Solved using a message box with the various conditions and variables