I would guess it is expecting a range as a String, not a Range.
..ListFillRange = "A1:A10"

NickHK

"No_Spam"
egroups.com...
I have a dropdown form field in my excel sheet. I want to set the
"Input Range" value at run time based on a selection of another
dropdown. So when a user selects a value in dropdown1, it will populate
the range for dropdown2.


With Sheet1.DropDowns("dropdown2")
.ListFillRange = Sheet1.Range("A1:A10")
End With

This code is not working...