View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default message box - title change

I like named parameters:

MsgBox Prompt:="Instructions", Buttons:=vbInformation, Title:="New title here"

But you could use:
MsgBox "instructions", vbInformation, "new title here"
since those are the first three positional parms to the msgbox function.

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?


--

Dave Peterson