Fill a ListBox-control with values from another workbook

Posted on 2009-04-25
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")
Question by:dave5m
    LVL 23

    Accepted Solution

    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

    in your current workbook add a new sheet.  In A1 put this:

    Drag that formula down to row 10

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

    Hide your added sheet if you want...



    Author Closing Comment

    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.
    LVL 23

    Expert Comment

    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)


    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now