yes

the syntax is

msgbox prompt, buttons, title

VBA intellisence gives you the full list, but basically, whatever you use as
"title" will appear as the heading



"Bishop" wrote:

Can I change the name of a messege box to something other than Microsoft Excel?

Apparently I'm not understanding the syntax involved. I totally see what
you're talking about but the help file example isn't very helpful. This is
what I've tried:
MsgBox ("You have to fill in this information before you can
continue.",,"WARNING!",,)
I've tried every combination with and without , placeholders. I've tried
using no quotes. And I either get a "= expected" error or an "expression"
error.

The syntax required in the helpfile is: MsgBox(prompt[, buttons] [, title]
[, helpfile, context])

So why doesn't this work?


"Patrick Molloy" wrote:

yes

the syntax is

msgbox prompt, buttons, title

VBA intellisence gives you the full list, but basically, whatever you use as
"title" will appear as the heading



"Bishop" wrote:

Can I change the name of a messege box to something other than Microsoft Excel?

Ok, I see now. You can't use ()'s. Thanks.

"Patrick Molloy" wrote:

yes

the syntax is

msgbox prompt, buttons, title

VBA intellisence gives you the full list, but basically, whatever you use as
"title" will appear as the heading



"Bishop" wrote:

Can I change the name of a messege box to something other than Microsoft Excel?

you can

method 1
msgbox, "hello World",vbyesno,"my message"


method 2
if msgbox( "Continue?",vbyesno,"Program check")=vbNo THEN
///quit code
else
///continue code
end if



"Bishop" wrote:

Ok, I see now. You can't use ()'s. Thanks.

"Patrick Molloy" wrote:

yes

the syntax is

msgbox prompt, buttons, title

VBA intellisence gives you the full list, but basically, whatever you use as
"title" will appear as the heading



"Bishop" wrote:

Can I change the name of a messege box to something other than Microsoft Excel?