Drop down list

[andremayer]

Hi Everyone,

I have this button that I click on, and it prompts up a list of questions that another person must fill out. Some information must be typed in for example: REASON but some, I would like to have a drop down list to give them a choice of which options to choose from. Is there anyway to do this? Can someone please help!




Reply = InputBox(Prompt:="PAYMENT TYPE?", _
Title:="TYPE", Default:="AMEX")
If Reply = vbNullString Then

Else
ActiveSheet.Range("b27").Value = Reply
End If

 

[bensonsearch]

Hi,
Not from a input box. you can make sure it is a specific choice otherwise error and ask again but not drop down. Maybe instead use a userform to pop up that has a drop down list? so in essance the form is the msgbox