Solved: Changing the settings of a combobox

[ukdane]

Hi I have a combobox with the name "select" directly on a worksheet (it is a form control).
I want to write some code so that when an action is taken on another sheet, the code will adjust the ListFillRange accordingly.

I've tried using selectdestination.listfillrange = "B13:B15" but it doesn't work.
How can I change the properties of the combobox?

Thanks

[nst1107]

Try usingSheet1.Shapes("select").ControlFormat.ListFillRange = 'Enter range address here

[ukdane]

Hi, it's not a shape, but from the form toolbar, but it doens't matter, as I solved it myself. ¨

Thanks anyway for looking.