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