Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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" |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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" |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Simply use VbCr to break your lines. Eg:
MsgBox "Hello" & vbcr & "How are you?" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |