Notifications in Excel?

[Guest]

Is it possible to either have excel notify you when certain dates in the
worksheet come due or to export that information to another application that
will do that. I know that you can have a task created in Outlook however
with the amount of dates I'm working with, that would be somewhat impractical
since you have to manually setup each task. Is there an easier way to do
this? Thanks.

 

[Don Guillett]

does this help?

Sub datenotify()
If Date = "1/3/2005" Then MsgBox "hi"
End Sub

 

[CLR]

I can't give you the specific code, but I know it's possible to interrogate
a list of Excel files and extract specific cell values (dates?) and once in
your interrogation workbook, you can compare those dates to standards to see
if they coincide, exceed, etc........It's sorta reverse-english........it
will "tell" you, but you have to ask!..........

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Is this code written into the cell or is it done somewhere else?

 

[Don Guillett]

That was a macro. It you want a formula, try this.

=IF(TODAY()=DATE(2005,1,4),1,2)