View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
patterson_m[_5_] patterson_m[_5_] is offline
external usenet poster
 
Posts: 1
Default Messgae Box on Exit Application

I want to display a message box when the user 'exits' the application.

Sub Auto_close ()

MsgBox "THANK YOU FOR YOUR FEEDBACK ", vbOKOnly + vbInformation,
"From the Agreement Finance Team"

Application.Quit

End Sub


The problem is that the message box appears twice, each time prompting
the user to click ok.

Any ideas why or how I can stop this.

Thanks

Mark



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/