Creating a message box with multiple options

[spencerp237]

Hello.

I am wondering to how create a message box in VBA that allows the user to select one of multiple options. I have used vbYesNo before, but I am now trying to do things that go beyond just a simple yes or no and I'm not sure how to go about doing that.

What I have done in the past is make check boxes that sit on the worksheet, but if there is a way to get rid of this and put it all in vba that would be wonderful.

[GTO]

A UserForm would be your best option. That way you can have as many buttons/choices as you want.

Hope that helps,

Mark