Hello I'm trying to add a range of elements to a comboBox but every time I try to do it i get the message "Run-Time Error '1004' Application-defined or object-defined Error'.
Can any of you explain me what I'm I thinking wrongly, my code is:
Private Sub ComboBox1_Change()
With Worksheets("Aux")
ComboBox1.List = .Range(.Cells(1, "D"), .Cells(Limit, "D")).Value
End With
End Sub
Can any of you explain me what I'm I thinking wrongly, my code is:
Private Sub ComboBox1_Change()
With Worksheets("Aux")
ComboBox1.List = .Range(.Cells(1, "D"), .Cells(Limit, "D")).Value
End With
End Sub