View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default MsgBox line break

MsgBox "This is line #1" & vblf & "This is line #2"
or
MsgBox "This is line #1" & chr(10) & "This is line #2"
or
MsgBox "This is line #1" & vbnewline & "This is line #2"



Horatio J. Bilge, Jr. wrote:

I would like to add a line break to a message box. The VBA help file for
MsgBox says you can use a carriage return character (CHR(13)) or linefeed
character (Chr(10)), but I can't figure out how to use them.

What I have is something like this:

MsgBox("This is line #1"Chr(13)"This is line #2")

but this give me an error "Compile error: Syntax error"

Thanks for any help,
~ Horatio


--

Dave Peterson