Macro to add a New Line to Message Box Pop-up Windows in Excel

This is a very simple Message Box, pop-up window, macro for Excel that illustrates how to put new lines, the same thing as hitting the "enter" key in a Word document, within a pop-up window.

Sub MsgBox_Newline()
	MsgBox "Hi!" & vbNewLine & "This is a message box"
End Sub

The code that generates the pop-up window is simply MsgBox. There are other arguments for it, but, most of the time, you simply need to put text into the pop-up window and nothing more. To do that, just put quotation marks after MsgBox and start typing.

The added thing above is vbNewLine and this is what creates the new line in the message box.

You will notice that vbNewLine is surrounded by ampersands (&) and no quotation marks. In order to use this feature within text in the message box, you need to close the quotes around the text, such as"Hi!" above and then input the & before the vbNewLine and then another & before any more text that is also completely surrounded with quotation marks.

The only part of the above macro that must be surrounded with quoatation marks is the actual text output. This syntax can be kind of confusing at first, but play around with the above code in Excel and you will see what I mean.

I hope this helps! :)

---