Message box if duplicate found and clear the data from corresponding cells

[sahal]

NEED URGENT HELP!

HELLO

I have been trying to find a way to get this worked but have been unsuccessful.
I am trying to get a pop message when duplicate values are found in Column C which generates a unique code (only numbers) when values in column D,E,F,G,H,I,J,K and L are inserted ( in the same row), also I want to remove the values from D,E,F,G,H,I,J,K and L after getting the pop message.

Any help is greatly appreciated!

 

[JLGWhiz]

Thanks to JLGWhiz and L. Howard!! It worked fine without any error!
You guys are awesome!

Thanks for the feedback,
Regards, JLG