+ Reply to Thread
Results 1 to 4 of 4

List folder and files in UserForm

  1. #1
    Banned User!
    Join Date
    10-29-2012
    Location
    Europe
    MS-Off Ver
    2013, 2016
    Posts
    318

    List folder and files in UserForm

    Hello,

    Who can help me with a code to do the following:
    In a UserForm pressing a button to choose from a browser, a drive or folder, and list in TextBox1 (D:\ or E:\Excel).
    In a ComboBox to list all subfolders in the current folder.
    Because each folder has subfolders and files directly in the root folder I like:
    In ListBox1 to list files in the root folder, and if there are no files in Listbox1 not show anything.
    and in ListBox2 to list files in that folder.

    Let's say you choose drive D: \
    - In combobox to defend all my folders in that drive
    - In ListBox1 to defend my files in the root of drive D: \
    - In ListBox2 not defend me anything

    If I choose a folder browser
    - In combobox to defend my all subfolders in that folder
    - In ListBox1 to defend my files in that folder root
    - In ListBox2 to my files in the selected folder appear in ComboBox

    If there are any doubts ask me.
    Thank you.

  2. #2
    Banned User!
    Join Date
    10-29-2012
    Location
    Europe
    MS-Off Ver
    2013, 2016
    Posts
    318

    Re: List folder and files in UserForm

    hello...hi there...

  3. #3
    Banned User!
    Join Date
    10-29-2012
    Location
    Europe
    MS-Off Ver
    2013, 2016
    Posts
    318

    Re: List folder and files in UserForm

    I did it myself.

  4. #4
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: List folder and files in UserForm

    Hi Indi_Ra

    Quote Originally Posted by Indi_Ra View Post
    I did it myself.
    Great ! . And thanks for letting us know.

    Sorry no one got around to it for you.

    Could you share your results and code and User form.?
    It would be great to compare with the Thread i just answered which does all what you want, except your User Form bit.

    I did want to answer your Thread, but I have no experience with User Forms.

    Here is my Post just done.

    http://www.excelforum.com/excel-prog...ml#post4316824

    See how the codes compare with yours. It list all Folders and Files in the Active Sheet
    http://www.excelforum.com/developmen...ml#post4316795



    Please supply your file for a comparison, that would be very helpful.
    Sorry i was unable to do it for you. I had tried

    Alan
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

+ 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. List files in Folder using Dir
    By VijaySM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2015, 03:51 PM
  2. List files in folder
    By scubajon in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-09-2015, 07:56 AM
  3. macros to list all files in folder THEN get info from files?
    By jonyorker in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-06-2015, 03:11 AM
  4. [SOLVED] List Files in Folder?
    By venkatpvc in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-03-2013, 05:54 PM
  5. Noob 4 Help - Macro to LIST ALL FILES IN FOLDER and then IMPORT ALL LISTED FILES
    By StlSmiln in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-25-2012, 04:02 AM
  6. List All Files In Folder
    By Rikuk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-07-2009, 05:02 PM
  7. list files in folder
    By stoney1977 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-24-2009, 01:53 PM

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