PDA

View Full Version : Creating a message box with multiple options



spencerp237
03-24-2017, 10:02 AM
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
03-24-2017, 10:41 AM
A UserForm would be your best option. That way you can have as many buttons/choices as you want.

Hope that helps,

Mark