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.
Bookmarks