I would like to have a combobox in the sheet itself, not userform, that will dynamically populate with the constituents of a folder, such as C:\Users\mat\Desktop\Files. The contents of this folder will change and the combobox should reflect this. Any help with a code that will me to do this would be greatly appreciated.