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.

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

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


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

Thank you, that is exactly what I needed.