MsgBox Title

J

Jack S.

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.
 
C

Chip Pearson

Jack,

Try something like

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



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

Chip Pearson

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 said:
Syntax

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

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

Jack S. said:
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.
 
N

Numan

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
 
Top