Sorry to ask a quesion I know has been answered before but I can't find it.
I get a type mismatch with the following code.
Sub GetData()
UserForm1.ComboBox1.RowSource = Worksheets("Sheet1").Range("A1:A10")
End Sub
If I just use RowSource "A1:A10" then it works fine but I need to say which sheet to take it from.
I get a type mismatch with the following code.
Sub GetData()
UserForm1.ComboBox1.RowSource = Worksheets("Sheet1").Range("A1:A10")
End Sub
If I just use RowSource "A1:A10" then it works fine but I need to say which sheet to take it from.