I guess you must have a corrupt personal workbook.

Export the Userform delete the macro. Close excel, Remembering to save the Personal workbook.

Open Excel

Reload the Userform

And Pray.