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...
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...
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 Add Boxes, Buttons, Arrows, Speech-Bubbles, Hearts, and More to a Spreadsheet in Excel
Tutorial: In this tutorial I am going to cover inserting and editing Shapes in an Excel workbook, as...
Create a 12 Month Calendar With The Current Day Highlighted in Excel
Macro: Create a 12 month formatted calendar on a new tab in Excel with the current day highli...
Add a Drop Down Menu to a Cell in Excel - Data Validation Macro
Macro: Add a drop down menu or list to a cell in Excel with this free Excel macro. This is a...



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.


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...
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...
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 ...
Excel Forum