Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: getting a multiple option message board

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    n/a
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]
    Kind Regards,
    Ivan F Moala From the City of Sails

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •