I have a workbook which calculates stock levels based on a series of calculations. I need a warning box to pop up whenever the "Stock Total" goes negative, as this is something that isn't possible.

I have managed to find a few methods of getting it to work when a value is entered manually, however the "Stock Total" is calculated from cells across different worksheets.

Any help appreciated!