VBA and operator

[kwaring]

what is the syntax for the VBA and operator... for example

If a=b AND c=d Then

what is the AND syntax???
Thanks,
Kyle

 

[Jay Petrulis]

On 2002-03-24 13:42, kwaring wrote:
what is the syntax for the VBA and operator... for example

If a=b AND c=d Then

what is the AND syntax???
Thanks,
Kyle

Hi Kyle,

What you wrote is exactly what you would do.

If a = b And c=d then do something

or, with an If...Then...Else construct

If a = b And c=d then
do something
else
do something else
end if

Regards,
Jay

 

[kwaring]

Really??? Hmmmm something else must've been wrong!!! Thanks!