ActiveSheet.ComboBox1.ListFillRange = "C3:C10"


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

" wrote in
message ...
Can anyone tell me if there is any way that I can change
the ListFillRange or LinkedCell of a Combo Box which is on
a WORKSHEET NOT, REPEAT NOT on a FORM via a macro