"AND" & "OR" operators in VBA

[philwongnz]

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 (X>0) then
if(y>0) then
do something
end if
end if

I can truncate to something more easier

if(X>0 "and" y>0) then
do something
end if

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

Thanks

Phil

[Bob Phillips]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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 (X>0) then
> if(y>0) then
> -do something-
> end if
> end if
>
> I can truncate to something more easier
>
> if(X>0 "and" y>0) 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
>

[philwongnz]

Thanks for that.

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

Thanks

[Bob Phillips]

& concatenates, it is not a logical operator.

--
HTH

Bob Phillips

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

"philwongnz" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>