Line break in vba message box in Excel


How do I insert a line break in the VBA message box? (I tried ^p, but does not work). 

Besides, it is possible to make a bulleted list in VBA message box? How?

Thanks!

Jiri

Answer:

Msgbox ("Line1" & vbNewLine & "Line2" )

(for formulas, depending on your country, you might have to change ; with , or the opposite

 Other excel answers

 

 

You can find similar Excel Questions and Answer hereunder

1) How can I find the number of working days between 2 dates using VBA?

2) How to display messages boxes in VBA with the msgbox function

3) How can I get users to select a file for processing using my macro?

4) How can I get row count of filtered data?

5) How can I find the last used cell in a Column in VBA?

6) Here some explanations about XPATH. XPath is a syntax for defining parts of an XML document

7) How can I delete all shapes in a WorkSheet?

8) How can I update a listbox based on data in a list using VBA?

9) How can I hide a sheet completely from users (the sheet should not even appear in Unhide dialog box)?

10) Here an explanation about list box and how to control list boxes in Excel VBA

 

Here the previous and next chapter