Notifications in Excel?
 

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.

does this help?

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

--
Don Guillett
SalesAid Software

"cpme" wrote in message
...
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.

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





"cpme" wrote in message
...
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.

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

"Don Guillett" wrote:

does this help?

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

--
Don Guillett
SalesAid Software

"cpme" wrote in message
...
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.

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

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

--
Don Guillett
SalesAid Software

"cpme" wrote in message
...
Is this code written into the cell or is it done somewhere else?

"Don Guillett" wrote:

does this help?

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

--
Don Guillett
SalesAid Software

"cpme" wrote in message
...
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.