View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt[_31_] Matt[_31_] is offline
external usenet poster
 
Posts: 5
Default Need some help with Exit Event

Hi All- I've got an exit button in a user form that I want to
accomplish the following with when clicked-
1. Prompt the user to see if they want to save the form and associated
workbook.
2. If yes to save then ask to save as and where.
3. Exit form and excel.

Presently I have the following code associated with the button.
Obviously it's inoperable at this point. I've searched quite a bit to
find some similiar code, without much luck. Any help would be greatly
appreciated. Thanks.

Private Sub BtnExit_Click()
End Sub