ListFillRange from Table column

[natefarm]

What is the format for a ListFillRange property that needs to come from a column in a table? In my case, table is on as sheet called Parameters, the table name is CSRTable, and the column header is Name, which is also the 1st column.

Thanks!

[xlnitwit]

Untested but perhaps
CSRTable[Name]

[natefarm]

No, afraid not. Also tried Parameters!CSRTable[Name], and it didn't work either.

[Norie]

For the ListFillRange of what exactly?

If it's for a combobox/listbox on a sheet then I'm afraid you might be out of luck as you can't use table notation, you would have to use the usual sheet/range reference.

[natefarm]

Ok, will do. Thanks.

[xlnitwit]

You could perhaps create a name that uses the table address, then use the name in the listfillrange? That should make it dynamic.

[natefarm]

That does work! I had to create the name using Name Manager, rather than just selecting the range and naming it. Selecting the name resulted in a Refers To value of "=CSRTable[Name]", which still didn't work, so I explicitly changed it to refer to "=$A$4:$A:11", and that worked. I didn't expect it to work dynamically with table row additions/deletions, but it apparently does.

Thanks!

[Norie]

Does the list that appears in the listbox/combobox dynamically change when you add/delete from the table?

[natefarm]

Yes and no. Combobox values don't automatically update unless you close and reopen the workbook. I'm sure there's a way to refresh them through code, but I'm not concerned about that with this app, as the table is an employee list, and won't change very often.

[Norie]

If that's what you need to do then it might be an idea to add code to populate the combobox when the workbook opens, then you could use table referencing.

[natefarm]

No need. As I said above in response to xlnitwit, it works, and I marked the thread as solved. Thanks though.