• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 150
  • Last Modified:

on from close ?

Is there a way I can execute code when I click the X button to close the form, so I can do some clean up within my program etc.

thanks -cc
1 Solution

put this in your form code:

private sub Form_Unload(Cancel as Integer)

'' do what you want

end sub
Use the QueryUnload event of the form. In case you feel that you have to stop the form from closing set Cancel=True in you code in this event.

Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)

End Sub
Form events are processed as follows:

Unload, then Deactivate, then Close.

Depending on what you're doing, you could have "scope" issues if using unload and may want to put your code in the Close event.  For most cases, however, either should work just fine.

For a full listing of all the form/subform events and their order of processing, see:


Hope this helps,
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

cscorbetAuthor Commented:
Thank you for all your help, as bobbit31 was the first to sort my problem I will give him the points.

thanks again.
why the 'B' grade?
A request has been made to change the grade,  The expert feels the current grade does not fit the criteria of the intended guidelines.  Those guidelines are below.  If no response, I will review this question and grade accordingly..

E-E Admin

How Do I Know What Grade to Give?
Although we use an A-D scale here at Experts Exchange, it works differently than, say, school grades. If one or more Experts' proposals are accepted as answers, they should usually be given an A or B grade, since they have taken the time to provide you with a working solution. If a possible solution is incomplete - ask for clarification or details before accepting the answer and grading it. People should not be given lower grades because of incorrect grammar or because you just accepted their answer or comment to close the question. Keep in mind, your question and any follow-up comments should be focused so that there can be a specific answer. The following is a good guideline to follow when grading:

A: The Expert(s) either provided you with a thorough answer or they provided you with a link to information that thoroughly answered your question. An "A" can also be given to any answer that you found informative or enlightening beyond the direct question that you asked.

B: The Expert(s) provided an acceptable solution, or a link to an acceptable solution, that you were able to use, although you may have needed a bit more information to complete the task.

C: Because Experts' reliability are often judged by their grading records, many Experts would like the opportunity to clarify if you have questions about their solutions. If you have given the Expert(s) ample time to respond to your clarification posts and you have responded to each of their posts providing requested information; or if the answers, after clarification, lack finality or do not completely address the issue presented, then a "C" grade is an option. You also have the option here of just asking Community Support to delete the question.

Remember, the Expert helping you today is probably going to be helping you next time you post a question. Give them a fair chance to earn an 'Excellent!' grade and they'll provide you with some amazing support.
Per the above discussion by Computer101, the grade has been changed.

EE Admin
cscorbetAuthor Commented:
Agreed !

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now