View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Horatio J. Bilge, Jr. Horatio J. Bilge, Jr. is offline
external usenet poster
 
Posts: 135
Default MsgBox line break

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