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
[email protected]
"cpme" <[email protected]> wrote in message
news:[email protected]...
> 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.

Hi,

If the file is opened on a regular basis:
=IF(A2-TODAY()<10,"Only"&(A2-TODAY())&" days left","")
+ Conditional formatting can be used to highlight the text.

Regards,
Ola

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" <[email protected]> wrote in message
news:[email protected]...
> 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
> [email protected]
> "cpme" <[email protected]> wrote in message
> news:[email protected]...
> > 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
[email protected]
"cpme" <[email protected]> wrote in message
news:[email protected]...
> 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
> > [email protected]
> > "cpme" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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.
> >
> >
> >