Form_Unload help

hi,

if have a little problem on my Form_unload sub. When I close my form, a vbOkCancel messagebox appears. But when I press cancel, the form closes anyway. How can I solve this that when I click the cancel button, the form doesn't close.

Thanks
RuffRyder

Try something like:

Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
If MsgBox("Do you want to cancel unloading?", vbYesNo) = vbYes Then Cancel = True
End Sub

Depending on what the message in the MsgBox is, a Cancel button might not be meaningful. If it is, just replace vbYes with vbCancel and vbYesNo with vbOKCancel.

ok, thanks, i'll let you know if it works

No need, I know it works. :) ;)

thanx man, tried it & it works