Hiya, i'm currently attempting to write in a worksheet change event.
In column C I have a number in each row. This number is the 'maximum' (it differs a lot) amount of product that can be put in. In column E is the number of products going into that row. For example:
In column C1 the number is 3.
In column E1 someone puts 2 products in there.
This is fine.
What i want is for when someone tries to do this:
In E1 someone tries to put 4 products in there. I'd like for a msgbox to pop up -
Then i'd like E1's contents to be cleared.
E:E is the monitored range.
I just can't get my head around this, can someone help please?
In column C I have a number in each row. This number is the 'maximum' (it differs a lot) amount of product that can be put in. In column E is the number of products going into that row. For example:
In column C1 the number is 3.
In column E1 someone puts 2 products in there.
This is fine.
What i want is for when someone tries to do this:
In E1 someone tries to put 4 products in there. I'd like for a msgbox to pop up -
Code:
msgbox "Please do not put more than " & range("c1").value
Then i'd like E1's contents to be cleared.
E:E is the monitored range.
I just can't get my head around this, can someone help please?
Last edited: