Closing a User Form

**mikeymay** · Jan 25th, 2006, 06:52 AM

I have a User Form which includes a button 'Close Form'. This clears all the data entered on the form and on a worksheet.

If the user closes the form using the 'X' button at the top right of form, the code doesn't work.

How can I get the code to work when the 'X' button is used?

Thanks

**Mosabama** · Jan 25th, 2006, 06:54 AM

Try the Form (Closing) event ...

VB Code:

Private Sub Form1_Closing(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles MyBase.Closing
        MsgBox("Closed")
    End Sub

**Mosabama** · Jan 25th, 2006, 06:56 AM

oh .. I am sorry ... you are not talking about VB.NET...

**mikeyc1204** · Jan 25th, 2006, 08:35 AM

Take a look at UserForm_Terminate()

**DKenny** · Jan 25th, 2006, 09:31 AM

Check out my post here.http://www.vbforums.com/showthread.php?t=383513

**thelocaluk** · Jan 25th, 2006, 10:46 AM

Dkenny's solution is the way to go.

**RobDog888** · Jan 25th, 2006, 10:53 AM

Thats a good solution but the user might get confused if the clicking of the 'x' doesnt do anything so its good that you place the call to click the button.

Here is my CodeBank entry on how to disable the 'x' so its greyed out in case your interested.

http://www.vbforums.com/showthread.php?t=363931

**DKenny** · Jan 25th, 2006, 11:01 AM

Rob
In my method, I assume that the the cmdCancel_Click event runs whatever code is needed and then hides or closes the form - therby giving the user the impression that clicking the 'x' does close the form.

**RobDog888** · Jan 25th, 2006, 11:09 AM

Yes, I mentioned you had the call to the click event of the button.

Thread: Closing a User Form

Thread Tools

Display

Closing a User Form

Re: Closing a User Form

Re: Closing a User Form

Re: Closing a User Form

Re: Closing a User Form

Re: Closing a User Form

Re: Closing a User Form

Re: Closing a User Form

Re: Closing a User Form

Posting Permissions