MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Return in messagebox


Posted by Ben on April 17, 2001 11:40 AM

Does anyone know how to use return in a message box?
e.g. : One two three four five six seven eight nine
becomes: One two three four five
six seven eight nine


Posted by Barrie Davidson on April 17, 2001 11:50 AM


Try this-
"One two three four five" & Chr(13) & "six seven eight nine"

The Chr(13) inserts a line break.

Posted by Ben on April 17, 2001 1:07 PM

Thanks

Thanks


Posted by Ben on April 17, 2001 1:07 PM

Thanks

Thanks