MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Two Line Message Box


Posted by Jamie on May 19, 2000 11:13 PM

Hello all,
I would like to create a message box in excel 97 which consists of two sentences on two seperate lines within the same message box. I've read through the excel help file on message boxes several times but I can't quite seem to get the VBA code entered correctly.

Any and all help will be greatly appreciated.
Thanks.
Jamie


Posted by Ivan Moala on May 20, 2000 1:32 AM

Jamie
put in a Return charcter string chr(13)
eg Msgbox "Line feed" & chr(13) & "New Line starts"

Ivan

Posted by Jamie on May 20, 2000 8:31 PM

Thank you, that is exactly what I needed.

Jamie