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.

[cytop]

The only practical way to do this is to create a userform... The standard MsgBox is limited to the Yes/No/Cancel/Abort/Retry button captions.

[Lsxtrkiller]

I second the use of a userform.

If you want help creating a userform let us know.

Short of a userform you dont have many options.

[spencerp237]

Ah yes that makes sense. That totally slipped my mind and I've never used those within Excel. I guess my main question would just be the best way to go about doing that?

Am I able to set it up like the Yes/No message box where I just call it within the VBA and then use if statements?

Or would writing the code in modules and then calling the subs from the button click be the best way to go about this?

[cytop]

See http://gregmaxey.com/word_tip_pages/...ba_msgbox.html

Get it working first and you can be as creative as you want.

[spencerp237]

Awesome thank you very much!

[Lsxtrkiller]

When you create a userform you could do it either way.

You could set the code for each button on the form to call a sub that is written in a module or you could write in the code that you want each button to accomplish within the code for the useform button.

The choice there is yours.

I have done it both ways.

It really comes down to if multiple buttons will have some of the same functions. For example i have used a userform to make user-input changes to the document and then format the document the way i want it formatted.

Since i wanted the document formatted the same way every time I wrote my format sub in a module to call so i did not have to duplicate the code multiple times.

If each button is going to do something totally unique then writing the code in the button on the form probably makes sense.