Message box with listbox selection?

[ruub7]

Hello everyone,

I have a userform with several listboxes with different categories that people can choose options with. And after they click "generate results" I would like a message box to pop up that asks them how they would like the results to be shown to them.

Is it possible to do such a thing with a listbox inside a messagebox? Or perhaps is there a way to customize the buttons from the messagebox to present the text I want, instead of the usual "Ok, Yes, No etc"?

[kersplash]

Is it possible to use another userform rather than a msgbox?

[ruub7]

Erm... Can you tell a little bit more about what you mean exactly?
What kind of form control element do you think I should use for this?

Also, I don't want an extra tab that the users have to go through or having to change the lay-out of my current sheet to be able to accomodate an extra listbox or something like that (because with only 3 or 4 selection options that would leave a lot of empty space in the sheet and this selection has nothing to do with the other discisions the users make on the sheet, so I would prefer to keep it seperated from eachother somehow).

I would like a pop-up thingy, where the users get to pick out of a selection of 3 or 4 different options...
And wether that is some form control element that I hide and show with a macro based on a click on the generate button or something else, that doesn't matter to me.

I just don't know what button or msgbox or other thing to start with to be able to achieve this.

So if anyone can tell me that, then I will be on my way.

[ruub7]

Allright, I've been able to make something work with a group box with several option buttons in it.

Is it possible to make this into a pop-up thing?
Or would I need to do that in a crude way with hide/unhide commands?