Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Line in MsgBox
Anyone know how to start a new line in a MsgBox. For example, if I want to
have paragraphs in a Msgbox how do I do so? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Line in MsgBox
Hi
try msgbox "text1" & vblf & "text2" & vblf & "text3" -- Regards Frank Kabel Frankfurt, Germany exceller wrote: Anyone know how to start a new line in a MsgBox. For example, if I want to have paragraphs in a Msgbox how do I do so? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Line in MsgBox
Simply use VbCr to break your lines. Eg:
MsgBox "Hello" & vbcr & "How are you?" |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Line in MsgBox
Rather than tie this to one platform or another, I'd recommend
vbNewLine instead of vbLF since it works the same on both WinXL and MacXL. In article , "Frank Kabel" wrote: try msgbox "text1" & vblf & "text2" & vblf & "text3" |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Line in MsgBox
Hi JE
thanks for the info (as I unfortunately had never used a MAC before never would have noticed this) -- Regards Frank Kabel Frankfurt, Germany JE McGimpsey wrote: Rather than tie this to one platform or another, I'd recommend vbNewLine instead of vbLF since it works the same on both WinXL and MacXL. In article , "Frank Kabel" wrote: try msgbox "text1" & vblf & "text2" & vblf & "text3" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert a dotted line to a solid line in a line graph | Charts and Charting in Excel | |||
MsgBox line break | Excel Discussion (Misc queries) | |||
msgbox | Excel Discussion (Misc queries) | |||
coloring overy other line without doing so line by line | Excel Worksheet Functions | |||
MsgBox | Excel Programming |