Get file names from a directory

I have a macro that contains a drop down box with a list of file names that are contained in a single directory. Currently, I store the file names in a separate sheet and have to manually enter a new filename if a new file is added. Is there a way I can code something to pull the names of the files in the directory?

Please Login or Register  to view this content.

Charlize

Hi, This adds the File names to a "Control Toobox", "Combobox":-

Please Login or Register  to view this content.

Regards Mick

Thanks, combined a little bit of both and it worked great!