I'm having trouble with the AND operator when I used it 3 times.
If Text1.Text = "THIS" And Text2.Text = "THAT" and Text3.Text = "THOSE" then
Call Display
elseIf Text1.Text = "THIS" And Text2.Text = "THAT" and Text3.Text = "THOSE" then
Call Display2
else
MsgBox"Failed"
End If
It always ends up to the ELSE statement even if all the expressions are TRUE.
When I try to remove the 3rd expression (and Text3.Text = "THOSE"), it works.
Any way to round this? I tried using Goto, Select Case and nested If but does't work also.