Changing the name of a message box
 

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?

Changing the name of a message box
 

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?

Changing the name of a message box
 

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?

Changing the name of a message box
 

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?