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

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

Further debugging... I was able to fix the attached sheet. However MY personal workbook is not fixed. I simply removed Cancel = True in the above workbook. See attached....




In my actual workbook this is the culprit....

Please Login or Register  to view this content.

Anytime i set a control in the userform to a value on the spreadsheet in the query close event, whether that is directly hardcoded (above) or through a called function, the problem exists.

I can reset the form's memory by opening the second from and going into VbEditor and hitting the reset button. But that is precisely the only way I can reset the form.

...Back to my original statement. This IS a bug. And an annoying one that after 4 hours I can't seem to fix. This is wasting my time.

Thanks

If you change the QueryClose routine in the second userform, Add_Charges, to

Please Login or Register  to view this content.

It fixes the problem. The extra lines

Please Login or Register  to view this content.

were causing the problem. And those lines are unneeded since the form is already on the way to being unloaded without that code.
Also, I would remove all the code that you have in Edit_Charges QueryClose event. Again, there is no need to code for the hiding/unloading of a form in its own QueryClose event.

I've mocked up something that might help you.
In this example, the first userform (frmAlpha) takes a delimited string, from TextBox1, and "links" it to the two cells A1 and B1.
The sub form allows the user to enter the data into two textboxes, Textbox2 and TextBox3, and returns a delimited string the TextBox1 of the first form.

I've also included the same functionality in a single userform with a Multipage control. This approach eliminates the problems that come when piling one userform on a sub userform and keeping who is what straight. The multipage approach puts everthing in a single userform

Rule 08: Cross-posting Without Telling Us

Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

If you have less than 10 posts, do not try to copy and paste the link. Instead, type the link out in your thread.

No further help to be offered, please, until the OP has complied with this request.