ComboBox - Changing ListFillRange

C

colin.sidwell

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
 
B

Bob Phillips

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)
 
Top