Is there anyway to do the following.

I have 2 sheets

Sheet1
Sheet2

Most of the time I am in Sheet1

However Sheet1 is dependent on Sheet2


In column J on Sheet2 it can say

1. wait for purchase order
2. reschedule too many
3. blank(nothing)

What I want the workbook change to do is if any cell in column j on Sheet2 = wait for purchase order then have a msgbox pop up

If any cell in column j on Sheet2 = reschedule too many, then another msg box to pop up with different caption.

If blank, nothing.

Is there anyway that once it warns you for a specific cell, that you can cancel the warning. My problem is that the msg box keeps popping up, even though it already warned you once.

Thanks for any help

Josh