RE: $$Excel-Macros$$ Send Email Based on Change in Cell Value

2011-07-18 Thread Rajan_Verma
.From = "rajanverma1...@gmail.com" .TextBody = Str1 .Send End With Set cdoConfig = Nothing Set cdoMessage = Nothing End Function -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of s

$$Excel-Macros$$ Send Email Based on Change in Cell Value

2011-07-18 Thread setrasa
Hello, I have a worksheet that is updated by multiple users. When a user updates a cell to a certain value, I would like excel to send me an email notification that the cell has changed. I have the code to check for the event: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cell