Syntax for "and" and "or"
 

Can someone please show me the proper syntax for using "and" and "or"
operators with "if" in a Macro? Can they be used together?


--
knowtrump
------------------------------------------------------------------------
knowtrump's Profile: http://www.excelforum.com/member.php...o&userid=19664
View this thread: http://www.excelforum.com/showthread...hreadid=503802

Syntax for "and" and "or"
 

The best way is to use brackets to isolate the conditions.

If (A And B) Or _
(C And D) And _
(E Or D) Then
'do you stuff
End If

Note though that VB does not short circuit when testing, which can cause
problems, which are invariably worse, more likey, harder to debug with such
conditions. This means that even if a condition is met that would cause the
overall test to fail, it still runs the other tests. If they could give rise
to errors, you will get the error even if that test is irrelevenat in a
particular case.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"knowtrump" wrote
in message ...

Can someone please show me the proper syntax for using "and" and "or"
operators with "if" in a Macro? Can they be used together?


--
knowtrump
------------------------------------------------------------------------
knowtrump's Profile:
http://www.excelforum.com/member.php...o&userid=19664
View this thread: http://www.excelforum.com/showthread...hreadid=503802

Syntax for "and" and "or"
 

Sub M()
Dim i, j, k As Integer
i = 1
j = 2
k = 3
If (i = 1 And j = 2) Or k = 3 Then
MsgBox ("true")
End If
End Sub
____________________________
Gary's Student


"knowtrump" wrote:


Can someone please show me the proper syntax for using "and" and "or"
operators with "if" in a Macro? Can they be used together?


--
knowtrump
------------------------------------------------------------------------
knowtrump's Profile: http://www.excelforum.com/member.php...o&userid=19664
View this thread: http://www.excelforum.com/showthread...hreadid=503802