User form list box refering to another worrkbook
 

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

User form list box refering to another worrkbook
 

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" wrote in message
...
How do I refer to another workbook (open or closed) to display a list box
in
a user form?
Thanks
Hank

User form list box refering to another worrkbook
 

Just what I needed - Thanks Tom

"Tom Ogilvy" wrote in message
...
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" wrote in message
...
How do I refer to another workbook (open or closed) to display a list
box
in
a user form?
Thanks
Hank