Trapping the close button

[vbinfant]

hi,
can we trap the clicking of close button of a vb form. if so can even trap the alt + f4 command.
my main prob is i want to display the msgbox before closing the project. so that by clicking the ok button it has to close if they click cancel nothing should happen.
i tried to write it in unload function but i didnt find any solution.
plz can anybosy helps me plzzzz.

[PaulTilley]

Try looking into the query unload event. This has a parameter called UNLOADMODE. This should be what you are looking for.

Best Of Luck

[IGBP]

Try this ... I believe it works for both

Private Sub Command1_Click()
Unload Me
End Sub
 
Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
     If UnloadMode = vbFormControlMenu Then
          MsgBox "You cannot use that button", vbInformation + vbOKOnly, "Not allowed"
          Cancel = True
     End If
End Sub

[Madboy]

Originally posted by vbinfant
i tried to write it in unload function but i didnt find any solution.
plz can anybosy helps me plzzzz.

Unload isnt a function

[BuggyProgrammer]

Originally posted by Madboy
Unload isnt a function

that's very unecessary.... don't do that

[Madboy]

Originally posted by BuggyProgrammer
that's very unecessary.... don't do that

Sorry, but neither was your reply

Just letting him know, it might confuse people later on

[BuggyProgrammer]

Originally posted by Madboy
Sorry, but neither was your reply

Just letting him know, it might confuse people later on

what is one post if you wouldn't do that in that future