Pop up Reminder dialog boxes in Excel

[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.

 

[Gord Dibben]

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

 

[sumesh.rmy]

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.

thanks