Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form - Get Data From Drop List | Excel Discussion (Misc queries) | |||
User Form List Box | Excel Programming | |||
Creating a User Form to update a list | Excel Programming | |||
User Form / List Box | Excel Programming | |||
Creating a list box in a user form | Excel Programming |