Try attaching the workbook.

I don't e why you need to clear the userform before closing, this will happen anyway