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

--
HTH

Bob Phillips

"greenjellystar" wrote in message
...
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 :)