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
|