How can I code the 'x' button located on the top right of the form such that
it quits the application? or make it do something that I want.

Thanks in advance

paste behaind form:

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)

If CloseMode = 0 Then

'do something

MsgBox "You Pressed X"

End If

End Sub
--
jb


"sam" wrote:

> How can I code the 'x' button located on the top right of the form such that
> it quits the application? or make it do something that I want.
>
> Thanks in advance