Calculate Change

[Macro not running as intended]

I am trying to run a macro that will fire after a cell is calculated and
reaches a certain level. Where can I look for assistance in writing this
code? I'm pretty new to this and not really sure where to begin.

 

[Mike H]

Hi,

Use the worksheet_calculate event

Private Sub Worksheet_Calculate()
If Range("A1").Value >= 999 Then
'Do all manner of things in VB
End If
End Sub

Mike

 

[Joel]

You can use a calculate event wehich occurs every time a worksheet is
reculated

Private Sub Worksheet_Calculate()

If Range("C4").Value >= 10 Then
'enter your code here
End If

End Sub

Add code to the VBA sheet corresponding to the cell which you are
monitoring. don't use a VBA module sheet.