Take a look at Create a Simple Userform. That, combined with storing your variable text as AutoText should do what you want. Note, in order to have macros, or a userform in a template, it must be stored as a .dotm.