Hi there,

Just a quick question as to how do I use the "AND" & "OR" operators in
VBA. I know you can do it in excel where "AND(Logical,,,)" [same for
OR], can be used. But how do I do that in VBA? What happened if I have
and IF statement were it goes something like this:

if (X0) then
if(y0) then
-do something-
end if
end if

I can truncate to something more easier

if(X0 "and" y0) then
-do something-
end if

I know you can do it with Java where "&&" can be used for "AND"

Thanks

Phil


--
philwongnz
------------------------------------------------------------------------
philwongnz's Profile: http://www.excelforum.com/member.php...o&userid=26283
View this thread: http://www.excelforum.com/showthread...hreadid=564715

If X 0 AND Y 0 Then
'do something
End If

You have to be somewhat careful though as VBA does not short-circuit tests.
That is to say that if X is not 0 then there is no need to test the second
condition. But VBA does that test regardless, In many cases that is not a
problem, but sometimes it can throw an error.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"philwongnz" wrote
in message ...

Hi there,

Just a quick question as to how do I use the "AND" & "OR" operators in
VBA. I know you can do it in excel where "AND(Logical,,,)" [same for
OR], can be used. But how do I do that in VBA? What happened if I have
and IF statement were it goes something like this:

if (X0) then
if(y0) then
-do something-
end if
end if

I can truncate to something more easier

if(X0 "and" y0) then
-do something-
end if

I know you can do it with Java where "&&" can be used for "AND"

Thanks

Phil


--
philwongnz
------------------------------------------------------------------------
philwongnz's Profile:
http://www.excelforum.com/member.php...o&userid=26283
View this thread: http://www.excelforum.com/showthread...hreadid=564715

Thanks for that.

I noticed that you can use "&" as well? what's the difference?

Thanks


--
philwongnz
------------------------------------------------------------------------
philwongnz's Profile: http://www.excelforum.com/member.php...o&userid=26283
View this thread: http://www.excelforum.com/showthread...hreadid=564715

& concatenates, it is not a logical operator.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"philwongnz" wrote
in message ...

Thanks for that.

I noticed that you can use "&" as well? what's the difference?

Thanks


--
philwongnz
------------------------------------------------------------------------
philwongnz's Profile:
http://www.excelforum.com/member.php...o&userid=26283
View this thread: http://www.excelforum.com/showthread...hreadid=564715