Hi
in C9 user enters a customer number e.g. 124578 (mandatory must enter number)

then in C10 user enters a date 16/3/2010 (mandatory must enter date)


and from H20:H200 the user fails to enter required qty e.g. 2,5 or 100.

(mandatory, user must enter quantity in atleast one cell between this range).

and runs a macro

when this happens the macro must fail.

I want to stop the macro from being executed if all above 3 criterias are not fulfilled.

Can you please advise asap
Many thanks