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..