hi
a direct copy/paste from vb help....

Dim Msg, Style, Title, Help, Ctxt, Response, MyString
Msg = "Do you want to continue ?" ' Define message.
Style = vbYesNo + vbCritical + vbDefaultButton2 ' Define buttons.
Title = "MsgBox Demonstration" ' Define title.
Help = "DEMO.HLP" ' Define Help file.
Ctxt = 1000 ' Define topic
' context.
' Display message.
Response = MsgBox(Msg, Style, Title, Help, Ctxt)
If Response = vbYes Then ' User chose Yes.
MyString = "Yes" ' Perform some action.
Else ' User chose No.
MyString = "No" ' Perform some action.
End If

Press ALT+F11 to bring up the vb editor. in vb help, type MsgBox. click on
the Msgbox function for more details.

"Roger on Excel" wrote:

I have a userform which calls up a msg box

How does one change the title of the msgbox?

At present it reads Microsoft Excel - I want to change what it says

At present my code reads as follows

MsgBox "Instructions", vbInformation

Can anyone help with the correct syntax?