Thread: How to add drop down list in userform

Hi,
I am making a macro enabled excel sheet. In this sheet I am creating a user form which contains a dropdown list. The problem is that the data that I want in the dropdown list is arranged in horizontal. I want the user to select the grade of concrete in the user form drop down list the source of which is saved in sheet 2 (C1:H1) I could do it in selecting grade of steel as the data was arranged in vertical. When I input rowsource as "sheet2!C1:H1, in the property box Combobox2, I can only see M15 getting selected. I dont get a drop down list.
Please let me know if requires any special coding.
Thank you.

Try this in the "Userform Initialize" Event:-

Private Sub UserForm_Initialize()
With Me.ComboBox1
.RowSource = ""
.List = Application.Transpose(Sheets("Sheet2").Range("C1:H1").value)
End With
End Sub