On May 24, 8:36 am, "Sandy" wrote:
Perfect Susan, thank you
Sandy

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




"Susan" wrote in message

oups.com...



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

On May 24, 8:11 am, "Sandy" wrote:
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- Hide quoted text -

- Show quoted text -