Simple MsgBox question

[Gig]

I'm currently new to and studying VBA and having trouble understanding
the msgbox function.
Why is it that sometimes you have to include the arguments in
parentheses and other times you don't. I've noticed that when just a
prompt is required, it seems that the parentheses are not required.
Looked all over and haven't found an answer.
Thanks,
Greg

 

[Bob Phillips]

If you are just calling MsgBox there is no need for parantheses

Msgbox myMessage,vbYesNo

If you are returning the Msgbox result (the button pressed) and testing
that, parentheses are needed

If MsgBox(myMessage,vbYesNo) = vbYes Then
...

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Tom Ogilvy]

Just to add, that is a convention/the syntax for all functions and
subprocedures, not just for message boxes.