ukdane
04-02-2009, 04:10 AM
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
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