getting a multiple option message board

[dj_dafad]

how do I get a message board which has two options to click on? like "go to sheet 1" and "go to sheet 2" to come up in the middle of a macro and it does either if you click on either. again thank you to anyone who can help.
dj_dafad

[ This Message was edited by: dj_dafad on 2002-04-12 14:25 ]

[Ivan F Moala]

On 2002-04-12 14:24, dj_dafad wrote:
how do I get a message board which has two options to click on? like "go to sheet 1" and "go to sheet 2" to come up in the middle of a macro and it does either if you click on either. again thank you to anyone who can help.
dj_dafad

Amend this code to suit;

'// Start Msgbox Goto

If vbYes = MsgBox("Select YES to Goto [Sheet1]" & vbCrLf _

             & "Select NO to Goto [Sheet2]", vbYesNo) Then

    Sheets("Sheet1").Select

Else

    Sheets("Sheet2").Select

End If

'// End MsgBox Goto



'// The rest of your Code

[ This Message was edited by: dj_dafad on 2002-04-12 14:25 ]