1 Answer Found

The quick and dirty method is to use the listbox property called RowSource.You are able to assign the address of your list to that property and thelistbox will list the values in your table. The only downside is that ifthe dimensions of the list change you have to remember to go update theRowSource property.

The not as quick version is to use the worksheet or userform's activateevent to loop through your list and use the AddItem method of the listbox toadd all the items in the table. As long as the loop is dynamic, the listwill always display the values in your table even if the number of rowschange.