Multiple select option

[Gene Augustin]

I want a macro snippet to produce a message box with about 6 options to set
a variable value in the macro when it is run. It could be a drop down menu
or radio buttons or multiple choice in a message box.
Something like a case statement maybe

Select Case 'from box or drop down menu or radio button picked'
Case1
Location="Amarillo"
Case2
Location="San Diego"

Etc.
End Select

 

[Bob Greenblatt]

I want a macro snippet to produce a message box with about 6 options to set
a variable value in the macro when it is run. It could be a drop down menu
or radio buttons or multiple choice in a message box.
Something like a case statement maybe

Select Case 'from box or drop down menu or radio button picked'
Case1
Location="Amarillo"
Case2
Location="San Diego"

Etc.
End Select

This is not an appropriate use for a message box according to interface
guidelines. Use a small user form instead.