Hey! Thanks for the reply.

The reason I would like to keep the variable content in excel is that there is already an existing excel spreadsheet that I want to pull the paragraphs of text from. The text in these paragraphs may be periodically modified on the spreadsheet by other users.

To be honest though, I'm not sure how I would proceed even if I did store the variable content in the template containing the userform. I'm still quite new to VBA and have so far been able to get away with sticking together different pieces of code I've found online. Any further direction you can provide is greatly appreciated.

Thanks again!