+ Reply to Thread
Results 1 to 5 of 5

Dynamic folder list in Combobox

  1. #1
    Forum Contributor
    Join Date
    03-26-2014
    Location
    Kentucky
    MS-Off Ver
    Excel 2013
    Posts
    128

    Dynamic folder list in Combobox

    Is it possible to create a userform with a combobox or listbox that will display the contents a specific folder? Files will be added and removed from this folder on a regular basis and the box would need to reflect the current contents of that folder. I have attached a workbook that has a generic userform with the combobox. Any help with this would be great.

    Generic Userform for file select.xlsm

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,718

    Re: Dynamic folder list in Combobox

    See attached. You have to update the code for your "specific folder" where shown.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Dynamic folder list in Combobox

    Hi raydenUK

    Here's another...had it completed...

    Please Login or Register  to view this content.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  4. #4
    Forum Contributor
    Join Date
    03-26-2014
    Location
    Kentucky
    MS-Off Ver
    Excel 2013
    Posts
    128

    Re: Dynamic folder list in Combobox

    WOW!! Thank you both. This is exactly what I was looking for

  5. #5
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Dynamic folder list in Combobox

    You're welcome...glad I could help. Thanks for the Rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Add file names to combobox list from folder by date
    By Nu2Java in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-04-2014, 12:10 AM
  2. NON Dynamic ComboBox list
    By GaidenFocus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-03-2012, 12:30 PM
  3. Dynamic List for combobox
    By T De Villiers in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2008, 05:49 AM
  4. [SOLVED] How do I set the rowsource for a ComboBox for a dynamic list?
    By ndm berry in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2005, 09:05 AM
  5. Combobox with a dynamic list
    By Arishy in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-12-2005, 10:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1