This a 2 part question, both involving filling a listbox on a worksheet.

1.) How do I have the listbox have multple columns and have the data source
be B2:D12?

2.) How do I have a worksheet listbox populate from an un-opened workbook?

Everytime I enter for the ListFillRange =B2:D12 and that doesnt work. Thank
you in advance for anyone that helps.