Simple MsgBox question
Just to add, that is a convention/the syntax for all functions and
subprocedures, not just for message boxes.
--
Regards,
Tom Ogilvy
"Bob Phillips" wrote in message
...
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)
"Gig" wrote in message
oups.com...
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
|