If , then, and, or

[Robert]

Can "and" and "or" be used with If...Then statements? If
not, is there a work around? Thanks.

 

[Klaus Linke]

Can "and" and "or" be used with If...Then statements?


Hi Robert,

Sure, any of the logical operators can be used in the expression that is
evaluated in the "If ... Then ... Else".
Nothing keeps you from writing stuff like
If a < 100 And Not (b = 5 Or b = 10) Then ...

If not, is there a work around?

"Select Case" or nested "If"s may sometimes be good alternatives (easier to
read/write).

Regards,
Klaus

 

[Perry]

and look here

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/ht
ml/vaidxlogical.asp
(Note: two lines: 1 URL)

Krgrds,
Perry

 

[Guest]

It's perfectly all right to use logical AND an OR
expressions in an If..Then statement. If your expressions
are a bit complicted, be sure to include parentheses
around them to show VBA in what order to make the logical
decisions, e.g.,

If ((strDay="Saturday") OR (strDay="Sunday")) AND (blnSun
= True) Then ...