Does anyone know how I can have a pop up reminder built into an Excel spreadsheet that will go off twice (preferably). It will go off once, the first time the spreadsheet is opened, on the date that is set, and again 15 minutes before the time that is set in that file. It would be able to be set as many times as needed within the same file
Don't quite understand the second part but to run a messagebox on opening the file right click on a sheet tab and click on View Code. On the VBA screen that appears click on ThisWorkbook in the Project box. In the dropdown that says (General) select Workbook and you should get text. Enter below..
Private Sub Workbook_Open ()
Msgbox "yourtext"
End Sub
Got an answer for Randy Farber? Would you like to comment on the posted answers, or vote for the one which you think is the best?
Sign up for a free account, or sign in (if you're already a member).
Other people asked questions on similar topics, check out the answers they received:
Other people asked questions on various topics, and are still waiting for answer. Would be great if you can take a sec and answer them
