AND IF
这些关键字在
IF 控制结构中用于按顺序测试表达式，
直到 其中一个为
FALSE 或全部为
TRUE。
Expressions separated by
AND IF are evaluated from left to right until one is found to be
FALSE.
As in a regular
AND if all expressions evaluate to
TRUE then the test is
TRUE, however unlike a regular
AND, evaluation of expressions ceases when one expression of many returns
FALSE.
You cannot mix AND IF and OR IF keywords on the same line.
Hint:
if you want a mixture of And & Or conditions a creative use of parentheses (brackets) will help.
Ie.
If (((x=1) Or (y=1)) And bNote_XY) And (bThis Or bThat Or bTheOther) Then
See also