Calculate Change

  • Thread starter Macro not running as intended
  • Start date
M

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.
 
M

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
 
J

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.
 
Top