Hi All,

I'm trying to create a "message box" or "pop out window" to alert a user when the stock is low on the spreadsheet? I have already put in place the conditional formatting for individual cells to turn red etc etc, but I cant find any VBA help regarding the pop up alert.

All it needs to read is "Stock is Low - Please Order/Check Stock" and for there to be an "OK" only option. It would be ideal if, on pressing OK, it would send an email to our engineer as a reminder. Also it is in cell range C10 to C1000.

Any help is appreciated

Many thanks,
Henry