Re: newline in a msgbox

Tech-Archive recommends: Fix windows errors by optimizing your registry

MsgBox "The categorical total for SUPPLIES is: " & _
vbNewLine & cat & vbNewline & _
" Have a great day!", vbOKOnly, "Category Total for SUPPLIES"

Other constants that will work in Windows

vbCrLf
vbCr
vbLf

But vbNewLine is better for compatibility with the Mac.
--
Regards,
Tom Ogilvy


"greenjellystar" <greenjellystar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D9739BC4-A627-4E6B-BF14-9121AC70D1ED@xxxxxxxxxxxxxxxx
> hello...i can't get my msgbox to display multiple lines...can someone help
me
> with this...my code is below...
>
> Worksheets("Sup 31xx").Range("M13").Formula = "='Sup 31xx'!$L$10+'Sup
> 32xx'!$L$10+'Sup 39xx'!$L$10+'Sup 4xxx'!$L$10"
> Dim cat
> cat = Worksheets("Sup 31xx").Range("M13")
> MsgBox "The categorical total for SUPPLIES is: " & cat & " Have a
great
> day!", vbOKOnly, "Category Total for SUPPLIES"
>
> thanks and have a great one, jessie :)
>
>


.

Quantcast