email from excell based on cell value when updated

[landonh]

The pc user does not have internet access so I have to use a SMTP command line program [ sendemail ] is being used.

I need to send an email when a cell value is updated and meets criteria such as >600.

Any help will be greatly appreciated.

I am a good copy and paster with minimal programing experience.

Thanks
LAndon

 

[Ruddles]

If the cell is being updated by being actively changed by someone typing a value in to it or pasting a value in to it, you need to use the Worksheet_Change event:-

Private Sub Worksheet_Change(ByVal Target As Range)
 
  If Range("A1") > 600 Then
    ' invoke message sending routine here
  End If
 
End Sub

If it's being updated because it contains a formula and the worksheet has been recalculated, use the Worksheet_Calculate event:-

Private Sub Worksheet_Calculate()
 
  If Range("A1") > 600 Then
    ' invoke message sending routine here
  End If
 
End Sub

Let me know if you don't know where to put this code.

As for the 'message sending routine', you sound as though you have that covered - yes?

 

[AlphaFrog]

deleted