ExcelBanter - Multiple lines in MsgBox

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Multiple lines in MsgBox (https://www.excelbanter.com/excel-programming/287676-multiple-lines-msgbox.html)

NJF

Multiple lines in MsgBox

How do i get display text in a message box over multiple
lines?

Colo[_86_]

Multiple lines in MsgBox

Please look into "vbLf" in the VBA help.

---
Message posted from http://www.ExcelForum.com/

KJTFS[_20_]

Multiple lines in MsgBox

Insert a & chr(10) & where you want the break line.

Keith
www.kjtfs.co

--
Message posted from http://www.ExcelForum.com

Chip Pearson

Multiple lines in MsgBox

Try something like

MsgBox "Line One" & vbCrLf & "Line Two"

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"NJF" wrote in message
...
How do i get display text in a message box over multiple
lines?

All times are GMT +1. The time now is 12:21 PM.