How to use worksheet change code

[CHERRYBERRY]

I have to run macro when automatically when value of cell change automatically. My code works perfectly when i change the cell value manually.

 

[Kyle123]

Oops, I answered in the testing forum

Was the same as below anyway

 

[SteveO59L]

try worksheet_calculate

 

[VoG]

Try

Private Sub Worksheet_Calculate()
'your code here
End Sub

 

[CHERRYBERRY]

I tried the code but its showing run time error 424

 

[SteveO59L]

Try posting the code you are using

 

[CHERRYBERRY]

Actually i am monitoring the values of different machines. So as the value of machine changes. The cell value of my excel sheet automatically changes. I want to run mymacro when the value changes automatically

 

[CHERRYBERRY]

Private Sub worksheet_calculate()




If Not Intersect(TARGET, RANGE("E31:H31")) Is Nothing And Cells(31, 6) > 8 Then
Application.EnableEvents = False
alarmsave
Application.EnableEvents = True
End If
END SUB

 

[VoG]

There is no Target argument with that event. Try

If Cells(31, 6).VALUE > 8 Then

 

[CHERRYBERRY]

Its still showing the same error