View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ryan H Ryan H is offline
external usenet poster
 
Posts: 489
Default Message Box - Formatting Question

I would do it this way. Hope this helps! If so, let me know, click 'YES'
below.

Sub Msg()

Dim Sentence1 As String
Dim Sentence2 As String

Sentence1 = "IF IMPORT WAS SUCCESSFUL click 'MOVE RECORD LIST TO DRIVER
LIST' to finish the import."
Sentence2 = "IF THE RECORDS DID NOT IMPORT CORRECTLY click 'CANCEL
Import ' and start over."

MsgBox Sentence1 & vbNewLine & vbNewLine & Sentence2

End Sub

--
Cheers,
Ryan


"Munchkin" wrote:

Below is my message box. I want the 2 sentances to be on 2 separate lines.
How to I get a return key inbetween them to do that?


MsgBox ("IF IMPORT WAS SUCCESSFUL click 'MOVE RECORD LIST TO DRIVER LIST'
to finish the import. IF THE RECORDS DID NOT IMPORT CORRECTLY click 'CANCEL
IMPORT' and start over.")