Msgbox w/ multi-lines

[jt46]

By using "Msgbox", I want to have multi-lines in 1 msg-box. Is thi
possible? Please help. Thanks.

Joh

 

[Soniya]

Hi John

MsgBox "Line1" & Chr(13) & "line2" & Chr(13) & "Line3"

 

[Geof Wyght]

The alternative to Soniya's is to use vbCrLf instead of
Chr(13).
Geof.

 

[Guest]

Hi John

And yet another example:

Private Sub CommandButton1_Click()

Money = Format(10, "$##,##0.00")

MsgBox "Please bring " & vbLf & _
"a #2 Pencil " & vbCr & _
"a sheet of paper " & Chr(13) & _
"and " & Chr(13) & Chr(13) & _
"at Least " & vbTab & Money & _
" ! ", vbOKOnly, "Good Luck TK"
End Sub

Good Luck
TK

 

[Degsyb]

Use the vb constant vbcr for a carriage return or vbcrlf for a
carriage return with line feed

 

[Degsyb]

It's better to use the VBA constants such as VBcr or VBcrlf

 

[Degsyb]

Hi John

MsgBox "Line1" & Chr(13) & "line2" & Chr(13) & "Line3"

 

[Degsyb]

Sometimes Chr(13) etc don't work in VBA.

Better to use the VB constants such as VBcr or VBcrlf

Ths emove the pointer down to the next line and never fail that I know
of.

 

[Degsyb]

Use vbcr for carriage return or vbcrlf to put in a line feed.

Chr(13) does not always work however trhe vb constants do

 

[Tom Ogilvy]

the vb constant vbNewLine is designed to work both with the PC and the
MAC. since no one else has mentioned it . . . <g>

 

[uecem]

Another alternative would be to use vbnewline for example:

msgbox "I want to start a new line" & vbnewline & "here.

 

[uecem]

Try the following:

Dim intResponse As Integer

intResponse = MsgBox("Click Yes or No.", vbYesNo)
If intResponse = vbYes Then
MsgBox "You clicked Yes."
ElseIf intResponse = vbNo Then
MsgBox "You clicked No."
End If :