| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
new line in msgbox text
what character(s) do you use to put a new line in msgbox text
msgbox "This is on one line ??? This is on the next" I expect its easy but have tried lots of things! Thanks -- Patrick |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
new line in msgbox text
Hi Patrick,
Try: MsgBox "This is on one line " & vbNewLine & "This is on the next" --- Regards, Norman "Patrick" wrote in message ... what character(s) do you use to put a new line in msgbox text msgbox "This is on one line ??? This is on the next" I expect its easy but have tried lots of things! Thanks -- Patrick |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
new line in msgbox text
Try
msgbox "Text Line 1" & vbcrlf & "Text Line 2" Cheers Nigel "Patrick" wrote in message ... what character(s) do you use to put a new line in msgbox text msgbox "This is on one line ??? This is on the next" I expect its easy but have tried lots of things! Thanks -- Patrick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MsgBox text on several lines | Excel Discussion (Misc queries) | |||
| MsgBox line break | Excel Discussion (Misc queries) | |||
| New Line in MsgBox | Excel Programming | |||
| VBA MsgBox() Text | Excel Programming | |||
| Wrong text in msgbox | Excel Programming | |||
Linear Mode
