Combo box inside a msgbox

[solowcx]

Hi, new to Excel, and had a question.

I have been looking for a way to have a combo (or drop down) box inside of a pop-up msgbox. The user in the message box would only be given the options inside the drop down box and then whatever they chose would be stored in a variable.

I know you can have an inputbox store its value into a variable, but I have not been able to find any information about including combo boxes.

Thanks in advance.

 

[Anthony47]

Hi solowcx,
you need to create a User Form with a combobox; I found very useful, when creating my first UserForm, these instructions:
http://www.mrexcel.com/tip009.shtml
and these:
http://www.contextures.com/xlUserForm02.html

I believe you will get all you need there, but if you need any help this forum is for you.

Bye,