No, the use is more in keeping with natural languages:
If Myvar 0 And Myvar < 10 then ....
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"WLMPilot" wrote in message
...
Do I follow the same format in a macro as I do in a spreadsheet for the
following?

IF(AND(test1, test2))

If not, what would be the correct way to test the value of multiple
fields.

I wanted to test the value of optionbutton1 and optionbutton 2 and if
either
were TRUE, THEN...........

Thanks,
Les