Make the Listbox fill with Dyantimc Range

[lee.tah.sung]

i have active listbox and i need to make it fill with Column and stop when the Cell is Blank so how i can do it ,

Please i need ur Helps !!

[PCI]

You can used a name defined with an OFFSET function
e.g. Names =OFFSET('ListBox List'!$A$2,0,0,COUNTA('ListBox List'!$A$2:$A$200),1)
See attached a personal file used as a reminder