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;<pre/>
'// 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</pre>
This message was edited by dj_dafad on 2002-04-12 14:25