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
Bookmarks