is it possible to set popup reminders in a excel worksheet

  • Thread starter Thread starter ed
  • Start date Start date
Yes

Gord Dibben MS Excel MVP
Click to expand...
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.

Regards,
Matt Richardson
http://teachr.blogspot.com
 
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.

Thanks you much
 
Yes


Gord Dibben MS Excel MVP
Click to expand...
Sir,

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

pls reply
 
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
 
Back
Top