New line in msgbox

  • Thread starter Thread starter Jone
  • Start date Start date
J

Jone

Ho do I make a new line in a msgbox in VBA ?
I know in a macro msgbox is this a new line "@" But looks like not in VBA
 
Hi Joone

You can do it like this


Sub boxer()


MsgBox "hello" & vbCrLf & "goodbye"


End Sub
 
Jone said:
Ho do I make a new line in a msgbox in VBA ?
I know in a macro msgbox is this a new line "@" But looks like not in VBA
Click to expand...

Dim msg As String

msg = "This is the first line" & vbCrLf
msg = msg & "and this is the second line." & vbCrLf
msg = msg & "Geddit?"

Debug.Print MsgBox(msg, vbQuestion + vbYesNo)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Multiple Line handling with Split() 1
Excel Need assistance with modifying a Duplicate declaration. 13
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Msg - could not update; currently locked by another session 13
How to write a new entry in a combo box to its underlying table 1
Msgbox Function - increase font size? 1
Outlook events stop work randomly 0
linefeed in msgbox 2

Back
Top