VBA Form Not Unloading / Memory Stuck - How to unload top form correctly

[ironfelix717]

Hi,

I have had this issue before. I had once thought it was a bug with the QueryClose event class.

See my post here: https://www.excelforum.com/excel-pro...ose-event.html

My textbox value in my topmost form is not clearing... because the form is not unloading. DESPITE me explicitly telling the form to unload and hide regardless of where i put that code.

You will see in the attached example that my form never unloads. When the first form opens, it always re-sets the cell value to "1000" which is correct. However, youll find that after editing the textbox in the second form, reloading the entire process no longer allows the textbox in form 2 to display "1000". It shows what was last entered... because its hanging in memory.


In my thread from some months ago (above), it was temporarily solved via setting the form object to nothing.

However, I have had no success this time.

Some other points:
I need two forms - no negotiating there, sorry.

Prefer to have the query close event close the form instead of a dedicated button. I want the X button to close the form.


Any help is greatly appreciated. Been on this for hours -_-

Thank you


*Also posted here:

https://www.mrexcel.com/forum/excel-...nt-unload.html