Listbox to display files within a folder

I have a listbox in which I want to display files fom within a set number of folders, identified by typing the folder name into a textbox.

The folders will all be in the same location and will be named by year (2013, 2014, 2015 etc.)

I have a problem with the error handling when the typed folder name does not exist, and also the code I have been playing around with produces the file list ok apart from that I have to duplicate it for every year that will exist going forward....! Is there to dynamically change it??

Please help

Please Login or Register  to view this content.

Double post? Where?

I'm not very good with vba and your function solution appears to me to one which populates a list in a worksheet. I just want the files to be displayed in a listbox on the userform.

Take a look at this workbook and let me know if you need help integrating it into your current project

I have attached what I'm working with, most of the coding has been removed to just leave the elements I'm having trouble with...

The set combobox creates a defined number of sheets...

The Month and Year comboboxes combine to display the files listed within folders dicated by the selections made in those comboboxes, i.e. Sep 2013 will display files shown in the folder "Sep" within folder "2013"...

The listbox will list the relevant files for review (to make sure that all the relevant ones are present)and then allow me to select them all so that when the 'Create' button is pressed the following happens,

The relevant sheets are created depending on the Set result.
All the relevant files are opened from which data can be copied into the sheets created in the last step.

I'm struggling with didplaying the files due to the combination of month and year and the error created if the folders have not yet been created...I thought it would be relatively straightforward....but alas, no.

Can anyone suggest a solution or am I going the wrong way about it?