Help with MessageBox coding for newbie

[Guest]

Hello All,

I need help with coding. I need a Warning Message Box "Re-Order Stock Now"
(with OK button) to appear on all of my 30 product worksheets when the stock
balance<= the reorder level for the product. All worksheet transactions are
manual input. Re-Order levels are always stored in cell J9 of the worksheets.
Stock
balances all appear in column D (D9100).

Thanks in advance for all help/advice.

 

[Guest]

Why not just use Conditional Formatting (Format -> Conditional Format) When
Cell value is less than 30 highlight the cell Red or something...