Closing a User Form

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

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

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

Take a look at UserForm_Terminate()

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

Dkenny's solution is the way to go.

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

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.

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