Send Email When Cell Value Changes
 

Hello,

There is a single, critical cell in a workbook that i need to be
notified when the value changes in any way. I would like to be
notified by email. My office runs on Exchange Server and Office 2003.

The value might change a couple of times prior to saving, so it
would be best if the email that was generated was done after saving and
on closing the spreadsheet.

I do not need to send the worksheet or any data, just a note that
states that the critical cell has changed.

Any help would be appreciated.

jonah

Send Email When Cell Value Changes
 

Hi

Try
http://www.rondebruin.nl/mail/change.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


wrote in message ups.com...
Hello,

There is a single, critical cell in a workbook that i need to be
notified when the value changes in any way. I would like to be
notified by email. My office runs on Exchange Server and Office 2003.

The value might change a couple of times prior to saving, so it
would be best if the email that was generated was done after saving and
on closing the spreadsheet.

I do not need to send the worksheet or any data, just a note that
states that the critical cell has changed.

Any help would be appreciated.

jonah

Send Email When Cell Value Changes
 

Hi Ron,
I had seen your posted suggestion before and hoped you would refer
me to it yourself. The difficulty i'm having is amending the
worksheet_change to recognize that the cell has changed in any way, not
just over 200.

I'm assuming that i insert the Mail_CDO as 'yourmacroname' when i've
got the Worksheet_change sub recognizing the changed cell.

jonah

Send Email When Cell Value Changes
 

Hi jonah

Remove the test then

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Range("A1"), Target) Is Nothing Then
YourMacroName
End If
End Sub


I'm assuming that i insert the Mail_CDO as 'yourmacroname' when i've
got the Worksheet_change sub recognizing the changed cell.

Correct


--
Regards Ron de Bruin
http://www.rondebruin.nl


wrote in message oups.com...
Hi Ron,
I had seen your posted suggestion before and hoped you would refer
me to it yourself. The difficulty i'm having is amending the
worksheet_change to recognize that the cell has changed in any way, not
just over 200.

I'm assuming that i insert the Mail_CDO as 'yourmacroname' when i've
got the Worksheet_change sub recognizing the changed cell.

jonah

Send Email When Cell Value Changes
 

Ron,
Thank you for this help. I've got the Worksheet_Change event
running and can prompt simple macros to run. However, the Mail_CDO
macro stalls on .Send. The Error message i get is:

Run-time error '-2147220960 (80040220)':
The "SendUsing" configuration value is invalid.

Any help would be appreciated.

Send Email When Cell Value Changes
 

Ron,

It's okay, i just figured it out! Thank you for your help!

jonah