Pop up Reminder dialog boxes in Excel

  • Thread starter Thread starter tannerdude
  • Start date Start date
T

tannerdude

Does anyone know how to create these in excel? I have a spreadsheet that
when I go to close the application I want it to pop up an information box to
remind me to do a task and even open the application that is needed to be
performed.
 
Private Sub Workbook_BeforeClose(Cancel As Boolean)
MsgBox "Don't forget to do something"
If Not ThisWorkbook.Saved = True Then
ThisWorkbook.Save
End If

Code to open another workbook or start another application

End Sub

Right-click on the Excel icon left of "File"

Select "View Code" and paste the above into that module.

Alt + q to return to the Excel window.

Close the workbook.


Gord Dibben MS Excel MVP
 
Does anyone know how to create these in excel? I have a spreadsheet that
when I go to close the application I want it to pop up an information box to
remind me to do a task and even open the application that is needed to be
performed.
Click to expand...

thanks
 
Back
Top