ListBox Fill Range

If it is a form control listbox goto FormControl -> Control -> Input Range

If it is a activex control goto Properties -> ListFillRange (ex: Sheet3!A1:A5)

Or, since you named the range, you can just use that name as the ListFillRange, like below.

That way, your listbox will change automatically if you re-define the range of test.

test.png

you can let listbox' property "ListFillRange" equal "test" directly

Thanks getting close now, see data in listbox
Here is my name range

Please Login or Register  to view this content.

how do I set it so more item can be added to range and show up in list?

As long as you re-define your named range, and have your listbox set to that named range by name, the listbox will update automatically.

Can I set the range to change automatic if item is added in range.

Got it, Thanks everyone for your help

Please Login or Register  to view this content.