In the [prompt] argument of MsgBox, how do I start text on a new line?
Thanks.
Anne Troy - 20 Aug 2005 00:27 GMT
Did you want something like this? The vbCrLf is a return. The space and
underscore simply "continue" my code to the next line without breaking it.
Sub msgboxme()
MsgBox ("Blah blah " & vbCrLf & _
"and more blah blah " & vbCrLf & _
"and more blah blah blah.")
End Sub
************
Anne Troy
www.OfficeArticles.com
> In the [prompt] argument of MsgBox, how do I start text on a new line?
> Thanks.
Jezebel - 20 Aug 2005 00:43 GMT
Msgbox "Line 1" & vbcr & "Line 2"
> In the [prompt] argument of MsgBox, how do I start text on a new line?
> Thanks.
Jay Freedman - 20 Aug 2005 00:50 GMT
>In the [prompt] argument of MsgBox, how do I start text on a new line?
>Thanks.
Insert the constant vbCr in the proper place, like this:
MsgBox "Line 1" & vbCr & "Line 2"
--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Jezebel - 20 Aug 2005 02:47 GMT
GMTA
>>In the [prompt] argument of MsgBox, how do I start text on a new line?
>>Thanks.
[quoted text clipped - 7 lines]
> Jay Freedman
> Microsoft Word MVP FAQ: http://word.mvps.org
Jay Freedman - 20 Aug 2005 05:03 GMT
Precisely. :-)
>GMTA
>
[quoted text clipped - 9 lines]
>> Jay Freedman
>> Microsoft Word MVP FAQ: http://word.mvps.org
--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org