Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Fill a ListBox-control with values from another workbook

Posted on 2009-04-25
3
Medium Priority
?
247 Views
Last Modified: 2013-12-26
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")
0
Comment
Question by:dave5m
  • 2
3 Comments
 
LVL 23

Accepted Solution

by:
ahammar earned 375 total points
ID: 24232033
I don't know if you can do that or not, but one way would be to put another sheet in your workbook with formulas that are linked to ("C:\Users\Owner\Desktop\RealIndy\FilterApplication.xls")
and then use that sheet as the row source...You can hide the added sheet if you want so that it can't be seen

For example, say you want the row source to be A1:A10 of Sheet1 in
("C:\Users\Owner\Desktop\RealIndy\FilterApplication.xls")

in your current workbook add a new sheet.  In A1 put this:
='C:\Users\Owner\Desktop\RealIndy\[FilterApplication.xls]Sheet1'!A1

Drag that formula down to row 10

Now in the Row Source property put this:
SheetName!A1:A10
     Where SheetName is the name of your added sheet that you linked to your other workbook

Hide your added sheet if you want...

:-)
Albert



0
 

Author Closing Comment

by:dave5m
ID: 31574504
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.
0
 
LVL 23

Expert Comment

by:ahammar
ID: 24238505
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
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question