Separate lines in excel message box

  Desert Andy 12:35 20 Dec 07

I have put a message box into my excel spreadsheet. The message consists of text and then a text string, confirming the data that the user has entered previously is correct. Is there any way to force the text string to be on a separate line to the text.

  Chris the Ancien 12:38 20 Dec 07

It requires the use of a Chr code.

Typical statement...
Alert = MsgBox("This action will add one new week to the end of the diary." + Chr(13) + Chr(13) _
+ "BUT will also delete the first week in the diary.", vbOKOnly, "New Week")

  VoG II 12:43 20 Dec 07

Or like this

MsgBox "Records searched:" & vbTab & Format(a, "00,000") & vbCrLf & "Elapsed time:" & vbTab & b & " sec"

  Chris the Ancien 12:48 20 Dec 07

I beat VoG™!!

This thread is now locked and can not be replied to.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Fresh New Fonts of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced