Text return in a MsgBox

E

easy

How do I create a text return or a new line of text in a VBA MsgBox?
Is it possible to display a bulleted list on a msgBox?
 
J

John Michl

Sub bulletmsg()
MsgBox ( _
Chr(149) & " This is the first item." _
& vbCrLf & Chr(149) & " This is the second item." _
& vbCrLf & Chr(149) & " This is the third item." _
)
End Sub

CHR(149) inserts a bullet character
vbCrLF inserts a line feed.

- John
www.JohnMichl.com
 
Top