MsgBox message on two lines?

[Sandy]

How do I get the following message to:
a) Split onto two lines in the message box (after the comma) and
b)Split it onto two lines within the code for readability?

MsgBox "You have missed out some entries, click OK and complete the list",
vbOKOnly, "Entries Missing"

Thanks
Sandy

 

[Susan]

msgbox "You have missed out some entries," _
& vbcrlf & _
"click OK and complete the list.", vbokonly, "Entries Missing"

this just enters one return
so it looks like this (return but no space between)

if you want it to enter two returns

so it looks like this (return & one line blank between)

msgbox "You have missed out some entries," _
& vbcrlf & _
vbcrlf & _
"click OK and complete the list.", vbokonly, "Entries Missing"

if you just wanted to split it within the code for readability:
msgbox "You have missed out some entries, " _ '<--***
& "click OK and complete the list.", vbokonly, "Entries Missing"


*** make sure you leave a space after the comma, or you'll end up with
"entries,click OK"
hth

susan

 

[Guest]

Put a carraige return in the string:-

MsgBox "You have missed out some entries, " & Chr$(13) & "click OK and
complete the list", vbOKOnly, _
"Entries Missing"


Mike

 

[Guest]

Sub sandy()
MsgBox ("Hello" & Chr(10) & "world")
End Sub

 

[Guest]

Sorry Sandy missed the second bit. Use the Undescore but it must have a space
in
front of it:-

MsgBox "You have missed out some entries, " _
& Chr$(13) & "click OK and complete _the list", vbOKOnly, _
"Entries Missing"

Mike

 

[Sandy]

Perfect Susan, thank you
Sandy

msgbox "You have missed out some entries," _
& vbcrlf & _
"click OK and complete the list.", vbokonly, "Entries Missing"

this just enters one return
so it looks like this (return but no space between)

if you want it to enter two returns

so it looks like this (return & one line blank between)

msgbox "You have missed out some entries," _
& vbcrlf & _
vbcrlf & _
"click OK and complete the list.", vbokonly, "Entries Missing"

if you just wanted to split it within the code for readability:
msgbox "You have missed out some entries, " _ '<--***
& "click OK and complete the list.", vbokonly, "Entries Missing"


*** make sure you leave a space after the comma, or you'll end up with
"entries,click OK"
hth

susan

 

[Sandy]

And thanks to you guys too
Sandy

 

[Susan]

Perfect Susan, thank you
Sandy

well, thank YOU, because i didn't know about the "Chr$(13)" bit......

susan