I have modified the userform and code to only present the prompts when the workbook doesn't exist in the same folder as the template.
I have made the list box wider.
The population of the list box requires the worksheet to be re-read for each change you make in the text box. With a very large worksheet it will take some time to read the data - hence the delays compared with the simpler test worksheet.
I'll leave you to make the rest of the changes.
If you want it faster you will probably have to work solely in Excel.
Reply With Quote