Having a Drop Down List in an UserForm

[ashperson95]

Hello again!

Okay, now I am trying to use a drop down list in a pop-up (UserForm) on my program. The data for the drop down list is located on Sheet1, and the pop-up will occur on Sheet2. I want the data that is chosen on the drop down to populate a column on Sheet2. I have been searching around on UserForms and drop downs but I can't really figure out how to organize the code to fit my situation. Here is the block of code I want this in:

locationNum = 1
For Each InfoInput In Range("Table2[Location]")


InfoInput.Value = InputBox("Name of location " & locationNum, "Name of Location")


fixtures = InputBox("How many fixtures does location " & locationNum & " have?")
InfoInput.Offset(, 1).Value = fixtures

'right here I want the pop-up with the drop down to appear and take the info and put it into a designated column


hoursDay = InputBox("How many hours a day do the fixtures in location " & locationNum & " run?")
InfoInput.Offset(, 3).Value = hoursDay


locationNum = locationNum + 1
Next InfoInput

Could someone explain how to create a UserForm for this situation?

 

[ashperson95]

Could someone try to help me with this?