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
Bookmarks