I have a macro that is used daily to format raw data and insert the names of seven individuals to complete a document. Every 3 months or so the names change. I've created a userform as an interface for the user to be able to change the names, but I'm stuck as to how to save the data once it is entered. Shouldn't I be able to save the template, the project, or the userform itself? In each of these scenarios the text in the userform goes back to the original names. Do I need to create persistent variables in the macro which are "read" each time the macro is run? Thanks in advance!