How show in Listbox (userform) specific files

Hi

I have in column E name files.

i need show inside listbox specific files (not all files), in folder, using range in sheet.

Goal: show file based name file in range inside ListBox.

Cross-Post
http://forum.chandoo.org/threads/lis...c-files.22531/

Att

Hi any idea?

Look my image and file to understand.

Not 100% sure if this is what you want, but...

Please Login or Register  to view this content.

How do when i click in button

Please Login or Register  to view this content.

and list files inside folder based my tab Sheet1 column E?

Att

Please Login or Register  to view this content.

However I would recommend using the Initialize event (see the code from my previous post). This way listbox will be populated during userform load. no need to click the button.

ok, my code get real file inside folder, your code not get real file insede folder.

Please Login or Register  to view this content.

When i inser in column E a false name file, you code list this false file, but this false file not exist in folder.

sorry, I don't get what you want...
files from the folder (that's what you have now) or file names from column E (that's what my code does) or something else e.g. only existing files, which are listed in column e?

Imagine you have, 120.000 files in a folder.
but you need to list a few (column E).

In column E has the name of the files that I wish list

that is what my code produces and it look exactly like your example
Clipboard01.jpg

ok, you code get value in column E.

I need code shearch name (based Column E), go to folder, if file name in column E exist in side folder then list them.

Originally Posted by marreco

if file name in column E exist in side folder then list them.

That is something you never mentioned (i.e. check if file exists), but anyway...

Please Login or Register  to view this content.

Hi buran, good good!!!

Thank you!!!!!!!!!!!

Great! Sorry for the initial misunderstanding :-)
Eventually you can make the function FileExists Private