Anniversary alert

[Francis Hookam]

Given dates of anniversaries are in a column in an spreadsheet can XL give
an alert of a pending anniversary on start-up?

And when already running?

Ok I shall build in days in advance, appropriate to the event, but that can
come later - it is the basics of how the get XL to recognise an imminent
event

I suppose some predetermined period will have to be set so, if the computer
is not turned on on the due day, the alert is still triggered until it is
cancelled

Any suggestions will be appreciated

Francis Hookham

 

[Bob Greenblatt]

You can use an Excel 4 macro to set the time of an alert. In your case, you
probably need a macro to run when Excel opens to scan your list of
anniversaries and set alerts based on your tolerance. Here's an example of
how to set an alert to fire in 30 seconds:

Sub settime()
Application.ExecuteExcel4Macro
("on.time(now()+""00:00:30"",""firealert"")")
End Sub


Sub firealert()
MsgBox "Time is up!"
End Sub


Watch out for line wrapping. The sub SetTime has only one line of code.