It will be impossible to show code for this issue as this code is all very private.
I am hoping that describing the steps to crash will be enough for anyone to point me in the right direction.
Here is the problem: I have a Worksheet that opens another Worksheet. That second Worksheet contain all my UserForms and common VBA code.
Everything run perfectly. However, it will Instant crash Excel with no indication of why, if I do the following: Open main Worksheet, run code that displays UserForm (through debugger, or button click), close UserForm, try to view form in Debugger.
If I open all related sheets, I can view the object or code, and switch between views, with no issue. Once that UserForm actually runs, any attempt to View that Object in Debug will instant-crash Excel.
There is this Windows Event at time of crash:
I followed this link and edumactated my stoopid self:
https://answers.microsoft.com/en-us/...b-8e9fb314bd54
Setting the appropriate Reg Keys exposed the error. I had removed a control from the form, but the code still referred to that "control.Value". There was also another undeclared variable.
RTFM in the extreme. I'm going to post this anyway, but mark it as Solved.
Bookmarks