I am trying to do this


Workbook_SheetCalculate()

If shPurchasing.Range(H8:H500).value = WAIT FOR ORDER Then

Msgbox "Wait for Order"

End if
End Sub

Where a msgbox would pop up on anysheet if Purchasing sheet Column H had the text WAIT FOR ORDER. I am new at VBA and don't know if I need to put anything in the opening brackets () after Workbook_SheetCalculate.

I would appreciate any help or insight. Thanks for your time.

Josh