Do another task when I press the X button

[seba18]

How can I associate another task with the close application button?

 

[mattKnight]

You can, but why?

The simplest way is to use the Form_QueryUnload Event, check the value of UnloadMode and set the cancel variable true.

something like

Private Sub Form_QueryUnload(cancel As Integer, unloadmode As Integer)
select case unloadmode
  case vbFormControlMenu
      'Do your task here
       Cancel = 1 'cancel form close
  case else
       cancel = 0
end select
end sub

but I can't see why you would want to do this!

Take Care

Matt
If at first you don't succeed, skydiving is not for you.

 

[seba18]

The reason for doing this is that I want to minimize the application in SystemTray(or ask user to minimize or close the program)

Thank's for the point mattKnight !

 

[mattKnight]

but I can't see why you would want to do this!

Oh I can now...


Glad it works

Take Care

Matt
If at first you don't succeed, skydiving is not for you.