View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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