Failing to trigger a message box when cell value in a range is less than 0

Hi folks,

I'm trying to make a message box pop up with a warning message/instruction when my stock level goes into negative stock, and it has been suggested VBA is the way forward.

I have had success using:

Please Login or Register  to view this content.

- where L3 is a cell containing a formula to display the stock level.

This works but only for the corresponding cell (L3), if i change it to L5 or L127 etc, it only triggers the message box for "errors" that cell, i.e. if the value is <0.

I attempted to change the cell to a cell range ("L3:L269") as you would normally write it in an Excel formula, but then I get an error window with "Run-time error '13':
Type mismatch"


I've attached my workbook, the column/cell range I'm trying to apply this to is column "L" (Stock Remaining) in the Jobs tab.
I'm very new to this and am a bit confused by all this new language, any advice will be gratefully received.

Consider using Conditional Formatting to highlight a cell (or Row) in say RED when the value is <0. You wouldn't need any code.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I did it for you this time. Please read forum rules. Thanks

This might be more efficient....

Please Login or Register  to view this content.