H Hank Hendrix Jul 17, 2004 #1 How do I refer to another workbook (open or closed) to display a list box in a user form? Thanks Hank
How do I refer to another workbook (open or closed) to display a list box in a user form? Thanks Hank
T Tom Ogilvy Jul 18, 2004 #2 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
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 Jul 18, 2004 #3 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...
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...
