limits of what you can and cannot fill a listfillrange with for ActiveX-Control Listbox

Hi,

What are the limits of what you can and cannot fill a listfillrange with for ActiveX-Control:

It seems like I can fill with = "Sheet1!A7:A78" OR = "=NamedRange"

Can I not fill it with an array?

This is good, but I have a few other uses that I'll be needing so I think I'll have to use an array. For instance the range that I'm starting off with has its start and end determined based on selections of by the user. I can't fill the range with a named range function because the listbox selections will clear at calculate.

Can I really not fill a listbox from an array?

Dagg,

So if I fill with ListFillRange then anytime I calculate it will clear selections? Also, basically am I now basically confined to load array with AddItem and loop?

Thanks! Ok so I'm using List, which I cannot believe I'm just now finding. 2 questions, this works with both listbox and combobox right?

Now I have another problem; but I think i need to mark this solved

Dagg,

So quick question, what's the limits of using List? I can load an array to it, but it doesn't seem to take a few inputs

i.e. cells(row, column)...............
or [Named Range Array Operation]