LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default newline in a msgbox

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 :)


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
newline Tree*Rat New Users to Excel 9 October 21st 08 05:19 PM
Insert newline in cell through formula (excel 2003) Bart Wouters Excel Worksheet Functions 2 July 23rd 07 04:04 PM
How to substitute a comma with a newline char using Replace. edspyhill01 Excel Discussion (Misc queries) 9 July 30th 06 12:38 AM
How do I ignore newline character/carriage return while importing Achal Excel Discussion (Misc queries) 6 March 24th 05 02:24 AM
DDE an Alt-Enter (Newline) character Ross Field Excel Programming 2 May 13th 04 04:12 PM


All times are GMT +1. The time now is 11:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"