Separate lines in excel message box

  Desert Andy 12:35 20 Dec 2007

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 2007

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 2007

Or like this

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

  Chris the Ancien 12:48 20 Dec 2007

I beat VoG™!!

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

Elsewhere on IDG sites

Honor 9 Lite review

How Sam Falconer transforms science and geology into digestible, elegant illustrations

HomePod review

Les meilleures séries Netflix (2018)