Link to home
Start Free TrialLog in
Avatar of dave5m
dave5m

asked on

Fill a ListBox-control with values from another workbook

what do i put in the RowSource-property for a ListBox- or ComboBox if i always want it to get data from ("C:\Users\Owner\Desktop\RealIndy\FilterApplication.xls")
ASKER CERTIFIED SOLUTION
Avatar of ahammar
ahammar
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dave5m
dave5m

ASKER

i think i can do that, i would have to open the page but hide it, but i do not know how to do that but this will work.
Thanks for the points...

While you are in the vb editor, select the sheet in project explorer where all your sheets and modules are listed.  In the properties window, the very last property will be the visible property.  You can select hidden, or very hidden.  very hidden just means that it can not be unhid from the Excel menu (because you can hide and unhide a sheet that way too, but not sure how...I never use that)

:-)
Albert