This has to be real easy, but I can't find it in books or
on this newsgroup...

How do I change the title in a MsgBox??

Thanks for the help.

Jack,

Try something like

MsgBox "Hello, World", vbOKOnly, "Title Goes Here"



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Jack S." wrote in message
...
This has to be real easy, but I can't find it in books or
on this newsgroup...

How do I change the title in a MsgBox??

Thanks for the help.

MsgBox "text prompt goes here", "TITLE GOES HERE"

You're missing a second comma before the title text.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Alex" wrote in message
...
Syntax

MsgBox(prompt[, buttons] [, title] [, helpfile, context])

MsgBox "text prompt goes here", "TITLE GOES HERE"

"Jack S." wrote:

This has to be real easy, but I can't find it in books or
on this newsgroup...

How do I change the title in a MsgBox??

Thanks for the help.

The syntax is different for InputBox, where Title is the second operand.

See your HELP and for some examples you might look at
InputBox, MsgBox and TextBox
http://www.mvps.org/dmcritchie/excel/inputbox.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Alex" wrote in message ...
Your right...

What's weird is how it's not needed for InputBox... That's what I was using.

Hi Jack,

As I think others have posted, the answer is this ( I am using a
example to highlight the message then the vb button and finally th
message box title):

response = msgbox ("Do you wish to continue", vbYesNo, "Continu
warning")

The commas are really important so remember to include them (which wa
my first mistake!!)

Hope that it helps

Numa

--
Message posted from http://www.ExcelForum.com