Need to create a UserForm with Dynamic Check-Boxes based on the Files in a specific folder

Need to create a UserForm with Dynamic Check-Boxes based on the Files in a specific folder

Dear Forum,

I need to access a particular folder and select the most recent file / Alphabetically Sorted excluding the Parent File in which the macro exists
For Ex - I have a Folder Named - PAN INDIA in which there are 36 Files from several Branches in PAN INDIA so I want the Macro to create a Userform with all the Files in this folder listed with a Lable and CheckBox to do further analysis on them as the Template file would also in this folder need to exclude the same from the UserForm, this list can be sorted in either ways Alphabetically or the most recent downloaded file in this folder.

As this requirement is not giving any data Output have not uploaded any attachment

Regards
e4excel

hI gURUS,

I am not conversant with using these Tools and that too dynamically, as depending on the no of files in the folder these Checkboxes need to be created

Bump a thread