Msg Box problem

  • Thread starter Thread starter Paul Watkins
  • Start date Start date
P

Paul Watkins

Hi
I want to split the message which i have below into 2 lines within the
msgbox

MsgBox ("help i'm stuck"), vbCritical


when the box is displayed i want it to read:-

help
i'm stuck

how can i adapt this?


Paul
 
Paul, try this

MsgBox "Help" & vbCrLf & "i'm stuck"

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
Paul

MsgBox "Help" & chr(10) & "I'm critical", vbCritical

To keep the code cleaner-looking, you may want to use the form:

MsgBox "This is the first line" & Chr(10) & _
"This is the second" & Chr(10) & _
"And the final line", vbCritical
 
Back
Top