Thread: msgbox Question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JakeyC JakeyC is offline
external usenet poster
 
Posts: 107
Default msgbox Question

Use the concatenate operator '&' to include Chr(10) in your string of
text.

ie MsgBox ("Hello there" & Chr(10) & "How are you")
should display:

Hello there
How are you

Chr(10) works a little like someone having pressed Return mid-sentence.