MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Calculate Event

Posted by Peter on November 02, 2001 4:13 AM

I am trying to display a message to the user when a value move outside a range. Unfortunatly the value is the result of a formula so the Change event does not work. I have been unable to find and good examples of the Calculate event so any help would be appreciated

Posted by Juan Pablo on November 02, 2001 4:15 AM

Try something like this on your Sheets module

Private Sub Worksheet_Calculate()
If Range("A3") > 200 Then MsgBox "Hey, you're OUTSIDE !", vbCritical, "Error"
End Sub

Where A3 is the cell you're checking.

Juan Pablo