VBA and operator

kwaring · Mar 24th, 2002, 02:42 PM

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 · Mar 24th, 2002, 02:59 PM

Quote:

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 · Mar 24th, 2002, 03:11 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 24th, 2002, 02:42 PM	#1
kwaring New Member Join Date: Mar 2002 Location: Nanaimo, BC Posts: 49	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

Mar 24th, 2002, 03:11 PM	#3
kwaring New Member Join Date: Mar 2002 Location: Nanaimo, BC Posts: 49	Really??? Hmmmm something else must've been wrong!!! Thanks!