I suspect that you shouldn't be using the ThisDocument module for your code. In the case of the code sitting in an attached template, ThisDocument refers to the attached template rather than the activedocument.

The Submit_Click code should be sitting in the userform's own module.

If that doesn't solve it, can you post your template?

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia