What is the difference between ListFillRange and List, when using ComboBoxes?

[Jamualson]

The following macro has the same output, however I can not use the 2 at the same so they throw error. (70, permission denied)

But seperately working well. Why are these 2 properties so similar and what is the different between then?

Thank you very much

Sub test()

With ComboBox1

.ListFillRange = "=Sheet2!B5:B10"
.List = Worksheets("Sheet2").Range("B5:B10")

End With

End Sub

 

[RoryA]

Using ListFillRange binds your control to a worksheet range. Using List you simply assign an array to the control - that array can be entirely in memory, or assigned from a range.

ListFillRange means that your control can use column headers, and will react automatically to changes in the source data, but it can also mean that your control events are triggered when you don't necessarily expect or want them to be - especially if you are using a dynamic range.

 

[Jamualson]

Using ListFillRange binds your control to a worksheet range. Using List you simply assign an array to the control - that array can be entirely in memory, or assigned from a range.

ListFillRange means that your control can use column headers, and will react automatically to changes in the source data, but it can also mean that your control events are triggered when you don't necessarily expect or want them to be - especially if you are using a dynamic range.

thank you very much. I guess this is the cause for the error as well. If list is already set, then listfillrange can be set also, no problem, overwrites.

But if ListFillRange is set, and then i want to add a list to it, it shows an error.

Why error is showing only in 1 of the 2 situation? Thank you very much again for your help

 

[RoryA]

Just the way it was programmed I guess. Once ListFillRange is set, that effectively supplies the List property, so you can't use it.