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

Add to Favorites

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! :)






Similar Content on TeachExcel
How to Add a New Line to a Message Box (MsgBox) in Excel VBA Macros
Tutorial: I'll show you how to create a message box popup window in Excel that contains text on mult...
Put Data into a UserForm
Tutorial: How to take data from Excel and put it into a UserForm. This is useful when you use a form...
Simple Alternatives to UserForms
Tutorial: This tutorial covers a few simple ways to show pop-up windows to users that allows you to ...
Input Form to Get Data and Store it in Another Tab in Excel
Tutorial: How to make a user input form in Excel and have the data stored on another worksheet at th...
Make Users Enable Macros in Order to View a Workbook in Excel
Tutorial: Tutorial showing you how to make a user enable macros in a workbook in order to view the ...
Excel Macro to Save a Specific Worksheet as a New File
Macro: This Excel Macro allows you to save a specific worksheet within the Excel Workbook to its ...



How to Install the Macro
  1. Select and copy the text from within the grey box above.

  2. Open the Microsoft Excel file in which you would like the Macro to function.

  3. Press "Alt + F11" - This will open the Visual Basic Editor - Works for all Excel Versions.  Or For other ways to get there, Click Here.

  4. On the new window that opens up, go to the left side where the vertical pane is located. Locate your Excel file; it will be called VBAProject (YOUR FILE'S NAME HERE) and click this.

  5. If the Macro goes in a Module, Click Here, otherwise continue to Step 8.

  6. If the Macro goes in the Workbook or ThisWorkbook, Click Here, otherwise continue to Step 8.

  7. If the Macro goes in the Worksheet Code, Click Here, otherwise continue to Step 8.

  8. Close the Microsoft Visual Basic Editor window and save the Excel file. When you close the Visual Basic Editor window, the regular Excel window will not close.

  9. You are now ready to run the macro.


Tutorial Details
Similar Content
How to Add a New Line to a Message Box (MsgBox) in Excel VBA Macros
Tutorial: I'll show you how to create a message box popup window in Excel that contains text on mult...
Put Data into a UserForm
Tutorial: How to take data from Excel and put it into a UserForm. This is useful when you use a form...
Simple Alternatives to UserForms
Tutorial: This tutorial covers a few simple ways to show pop-up windows to users that allows you to ...
Excel Forum