After many hours... I have simplified and solved the problem. Now I want to know why.
The following sequence of events with the following code will not crash excel when I view the instance: MyClass1 in the locals window by expanding it (clicking on the "+" that expands and displays all private variables defined in the instance of the class):
1: I step through a subroutine in a module: MySub_InModule() line by line until I set a new instance: Set Inst_MC1 = New MyClass1 (on a separate line from the Dim statement)
2: I expand Inst_MC1 to view all private variables (SUCCESSFULLY)
3: I call subroutine: MySub_InClass using the previously-defined instance: Call Inst_MC1.MySub_InClass(InputToMCSub)
4: I expand Inst_MC1 to view all private variables in the locals window (SUCCESSFULLY)
'/Module: Module1
'/Class Module: MyClass1
The difference in the code above and code below is in bold.
The following sequence of events with the following code will crash excel when I view the instance: MyClass1 in the locals window by expanding it (clicking on the "+" that expands and displays all private variables defined in the instance of the class):
1: I step through a subroutine in a module: MySub_InModule() line by line until I set a new instance: Set Inst_MC1 = New MyClass1 (on a separate line from the Dim statement)
2: I expand Inst_MC1 to view all private variables (SUCCESSFULLY)
3: I call subroutine: MySub_InClass using the previously-defined instance: Call Inst_MC1.MySub_InClass(InputToMCSub)
4: I expand Inst_MC1 to view all private variables in the locals window AND EXCEL CRASHES
'/Module: Module1
'/Class Module: MyClass1
The read-only property for Int2 is simply:
Bookmarks