Help with a message box with two options for the user which will run different code dependent on the option chosen

[Rich_B]

Hi

As per the title, I need a message box with two options for the user which will run different code dependent on the option chosen.

So for example:

The user clicks a button and is presented with two options in a message box "Option 1" and "Option 2". If option 1 is selected a certain piece of code executes. If option 2 is selected a different piece of code executes.

I'm envisioning a standard message box where I am able to edit the text on the two buttons to say "Option 1" and "Option 2". However, if there is an alternative or a better way of achieving the same result then I am always open to suggestions.

Thank you

Excel 2007
Win 8.1
PC

 

[JLGWhiz]

You can get a message box with a 'Yes' or 'No' option that can do what you want.

Sub t()
Dim ans As Variant
ans = MsgBox("Do you want to say hello?", vbYesNo, "CHOOSE YES OR NO")
    If ans = vbYes Then
        Yes
    Else
        No
    End If
End Sub


Sub Yes()
   MsgBox "Hello"
End Sub


Sub No()
    MsgBox "Bye"
End Sub

You can use the narrative of the message box to instruct the use on how to respond with the Yes or No option.