User form list box refering to another worrkbook

H

Hank Hendrix

How do I refer to another workbook (open or closed) to display a list box in
a user form?
Thanks
Hank
 
T

Tom Ogilvy

If you mean as the source of the data, the other workbook should be open
then set the rowsource to

[Myworkbook.xls]Sheet1!A1:B10
 
H

Hank Hendrix

Just what I needed - Thanks Tom

Tom Ogilvy said:
If you mean as the source of the data, the other workbook should be open
then set the rowsource to

[Myworkbook.xls]Sheet1!A1:B10

--
Regards,
Tom Ogilvy

Hank Hendrix said:
How do I refer to another workbook (open or closed) to display a list
Click to expand...
box
in
a user form?
Thanks
Hank
Click to expand...
Click to expand...
 
Top