View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
philwongnz[_6_] philwongnz[_6_] is offline
external usenet poster
 
Posts: 1
Default "AND" & "OR" operators in VBA


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