Populate a Listbox with external database

[nicola_1988]

Hi All,

I have a question. I have Workbook1 and Workbook2. I want to have in WB1 a userform with a Listbox populate with data taken from WB2 (sheet1).

Usually if I want a ListBox in a workbook, I use the following code. I would like to modify the code in order to have a Listbox as described above. I try but it gives me Error in Row Source.
Thank you!!!

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

[6StringJazzer]

You must use this format, but a reference to an external workbook will only work for this when the other workbook is open.

Please Login or Register  to view this content.