Multiple choice MsgBox

[osx99]

I am able to create a Yes / No Message box but is there a way to create more than two options with an alternative to yes /no?

Ideally I would want 10 options

Eg. Select one of the following and seperate code run based on each selection?

Option 1
Option 2
..
Cancel
etc

 

[HughLerwill]

I think you will find that the standard MsgBox will handle three options as in VbYesNoCancel however if you need more and you'd like to name them yourself you will have to construct a custom UserForm/ MsgBox of your own to do it.

 

[SkipVought]

Hi,

Option Buttons, otherwise referred to as Radio Buttons. You can get a mutually exclusive result.

Skip,

_{Just traded in my old subtlety...
for a brand NUANCE!}

 

[fumei]

Skip: "Option Buttons, otherwise referred to as Radio Buttons. You can get a mutually exclusive result. "

and

Hugh: "you will have to construct a custom UserForm/ MsgBox of your own to do it. "

The answer to your question is a userform. This is one of the things they are for.

faq219-2884

Gerry
My paintings and sculpture