email based on cell input
 

Hi, New to the forum. I have a simple tracking spreadsheet that i
shared by a number of users. When they enter a date in a cell in
particular column, I'd like to have that generate an automatic emai
notice to me that their task is complete. I've tried recording a macro
but I'm not having any luck. Should this be done in visual basic? Anyon
have a template or tip on the commands to accomplish this? Thanks

--
gm
-----------------------------------------------------------------------
gmw's Profile: http://www.excelforum.com/member.php...fo&userid=3115
View this thread: http://www.excelforum.com/showthread.php?threadid=50820

email based on cell input
 

Hi gmw

You can use the change even to run the macro
Example for A1

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


See this site for more info
http://www.cpearson.com/excel/events.htm

Which mail program do you use ?
On this page you find a few examples to send a text
http://www.rondebruin.nl/mail/change.htm




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


"gmw" wrote in message ...

Hi, New to the forum. I have a simple tracking spreadsheet that is
shared by a number of users. When they enter a date in a cell in a
particular column, I'd like to have that generate an automatic email
notice to me that their task is complete. I've tried recording a macro,
but I'm not having any luck. Should this be done in visual basic? Anyone
have a template or tip on the commands to accomplish this? Thanks!


--
gmw
------------------------------------------------------------------------
gmw's Profile: http://www.excelforum.com/member.php...o&userid=31157
View this thread: http://www.excelforum.com/showthread...hreadid=508203