Ask user question with multiple options

[rob1987]

Hello,

I have an Option Button which currently produces a yes/no option. and am using this code for example

Sub OptionButton1_Click()
myOutput = MsgBox("Are You Feeling okay?", vbYesNo)
If myOutput = vbYes Then
Call [Macro1]
ElseIf myOutput = vbNo Then
Call [Macro2]
 
End If
End Sub

Is it possible to set this up for different answers rather than Yes and No? For example could I have OptionA, OptionB and OptionC and then write my code so a different Macro runs depending on which option is selected?

Many thanks for reading and I hope someone can help or point me in the right direction.

 

[VoG]

Hi. You would need to use a userform or an add-in like ktMsgBox http://www.h3.dion.ne.jp/~sakatsu/ktMsgBox_Series_English.htm

 

[rob1987]

Thanks I'll check it out