Forum Discussion

Iron Contributor

Sep 15, 2021

Need Help - Userform Error Resulting in Excel Crash - "Automation error Exception occurred"

Greetings Excel Programmers, I've been experiencing a periodic error while testing code to one of my UserForms that causes Excel to crash without saving my work. It's not all the tim...

Iron Contributor

Sep 15, 2021

NikolinoDE, thank you for the response! I use F8 all the time and won't help here since the error occurs at a whim before even getting into the code. Copying into a new workbook didn't help it. I couldn't find a way the link you provided could help my case since Alex (on StackOverflow) stated that without the UserForm, his/her code still worked without any issues. And, all my code is thoroughly verified and works fine but something is wrong with the UserForm, like Alex's case. Since I'm working in a single workbook, perhaps, it's a memory issue you think? Also, I wish I could provide helpful code but 1) it's all part of the UserForm containing 3,921 code lines, and 2) correlates to the overall workbook structure (900KB and 12,440 code lines)

NikolinoDE

Platinum Contributor

Sep 16, 2021

Kendethar

This is a very ... but very long debugging to find the error.

Unfortunately, I can't help without the file here, my knowledge of the error of regenerating this vba code without the corresponding workbook is limited.

My guess is that it could be due to one or the other user form of the error.

But there can also be a SUB - Seperate procedure that could be outside the user form and when the work folder is opened, the procedure runs immediately and no user form is found because it only opens afterwards, the error occurs.

This procedure could also be in another worksheet / module.

Anyway and as I said I am not a VBA guru, I would have to have the file (without sensitive data) to run the VBA code individually.

Thank you for your understanding and patience

NikolinoDE

I know I don't know anything (Socrates)