Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA msgbox function
I want to have a msgbox prompt that has two lines of text, eg:
MsgBox("This is the first line this is the second line") I understand that I have to use a carriage return character, but can't seem to get the syntax right. Can anybody help? Les. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA msgbox function
MsgBox "First line" & vbNewLine & "Second line"
-- Vasant "LesLdh" wrote in message ... I want to have a msgbox prompt that has two lines of text, eg: MsgBox("This is the first line this is the second line") I understand that I have to use a carriage return character, but can't seem to get the syntax right. Can anybody help? Les. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA msgbox function
Les
Msgbox "This is the first line"&Chr(13)&"This is the second" -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "LesLdh" wrote in message ... I want to have a msgbox prompt that has two lines of text, eg: MsgBox("This is the first line this is the second line") I understand that I have to use a carriage return character, but can't seem to get the syntax right. Can anybody help? Les. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA msgbox function
Try this:
MsgBox("This is the first line" & vbCrLf & "this is the second line") HTH Alan P. "LesLdh" wrote in message ... I want to have a msgbox prompt that has two lines of text, eg: MsgBox("This is the first line this is the second line") I understand that I have to use a carriage return character, but can't seem to get the syntax right. Can anybody help? Les. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Function and msgbox | Excel Worksheet Functions | |||
MsgBox Function and Arguments | Excel Programming | |||
MsgBox Function and Arguments | Excel Programming | |||
MsgBox | Excel Programming | |||
MsgBox | Excel Programming |