How do you want the popup reminders to function exactly? Do you want
them to pop up when the workbook is opened, or following a particular
event, such as entering data into a specific cell. Please give us
more details so that we can help.
Hopefully, this is not off topic. Here is my scenerio:
have a excel spreadsheet that contains the date a request is received and
the date the request is due to the customers. How do I create a popup that
alerts the user three days prior to the due date, which request are due? I
will need for the popup to activate everytime the spreadsheet is opened.
I want to creat a popup reminder when we open worksheet, like every wednesday & thursday like " report to be sent urgently", u can specify cell A1 or any for values
Add this to Thisworkbook module if you mean when you open workBOOK.
Private Sub Workbook_Open()
If Weekday(Now) = 4 Or Weekday(Now) = 5 Then
MsgBox "send report immediately"
End If
End Sub
If you really meant workSHEET then ignore above and add this to
worksheet module.
Private Sub Worksheet_Activate()
If Weekday(Now) = 4 Or Weekday(Now) = 5 Then
MsgBox "send report immediately"
End If
End Sub
Gord
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
