Populating a listbox with data from another workbook

[uby]

Hello All!

Question...

I would like to populate a listbox with data from another workbook without having to create a worksheet to paste the information for that listbox, in that workbook. Is this possible?

Ex: Workbook 1, Sheet1 has the listbox.
Workbook 2, Sheet1 has the First and Last names in column C that I need to have in Workbook 1's listbox.

Your help is very much appreciated!

Thanks!


Uby

 

[mrmovie]

Cant you do something like

in your form load sub

Workbook("workbook2").Activate
Me.Listbox.Value.Add(ActiveWorkbook.Sheets("sheet1").Cells(1,1).Value

the code isnt right but i think you get the idea?

 

[uby]

THANK YOU SOOOOOOOOOOOOOO MUCH! That works nicely!

Thanks again!

Uby