MsgBox message on two lines?
 

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

MsgBox message on two lines?
 

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

MsgBox message on two lines?
 

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
"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

MsgBox message on two lines?
 

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

--
Gary''s Student - gsnu200724

MsgBox message on two lines?
 

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" 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

MsgBox message on two lines?
 

Perfect Susan, thank you
Sandy

"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

MsgBox message on two lines?
 

And thanks to you guys too
Sandy

"Sandy" wrote in message
...
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

MsgBox message on two lines?
 

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 -