MSg Box

[Urchino]

Hello,

I have this stupid question. Sorry bout it. I tried finding the forum but can't seems to locate (maybe wrong search).

Basically i wanted to list the items in the msg box as 1. , 2., 3. in a different line. How do i do write it in the VBA?

Sub Auto_Open()
'
' Auto_Open
'

'
    Worksheets("Main").Visible = xlSheetVisible
    Sheets("Main").Select
    MsgBox "Please follow the following steps " & _
            "1. Copy from main" & _
           "2. Pastre."


End Sub

Any idea?

Thanks guys for helping..

[WasWodge]

Try changing

MsgBox "Please follow the following steps " & _
            "1. Copy from main" & _
           "2. Pastre."

to

MsgBox "Please follow the following steps " & vbNewLine & "1. Copy from main" & vbNewLine & _
           "2. Pastre."

[Urchino]

Thank you. It is so simple.