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

If Me.OptionButton1 Or Me.OptionButton2 Then
MsgBox "both checked"
Else
MsgBox "none checked"
End If

--
Dan

On Jan 9, 8:51*am, WLMPilot <WLMPi...@discussions.microsoft.com>
wrote:
> 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

If test1 or test2 = true then...is valid, but generally better to be more
specific, If test1=true or test2=true then..
both of these are valid
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"WLMPilot" wrote:

> 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

Take a look at the "And Operator" topic in VBA Help...

If OptionButton1.Value And OptionButton2.Value Then

....


In article <1B0D1F61-2E23-4DFA-A7C8-(E-Mail Removed)>,
WLMPilot <(E-Mail Removed)> wrote:

> 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

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" <(E-Mail Removed)> wrote in message
news:1B0D1F61-2E23-4DFA-A7C8-(E-Mail Removed)...
> 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