Add range to combobox

[Padatwo]

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

 

[JoeMo]

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

The value of the variable "Limit" is not set anywhere in your code so it has the default value of 0. Cells(0,"D") is off the sheet which causes the error.