data validation not working while we paste the values (for removing duplicates in a column

I am not sure what you mean.

Are you saying it is useful and want to know how to change it, or that you can't use it so you don't know ... or something else?

You may want to provide more information (like a real example in use) to make sure we are on the same page if you want to get much further.

Or you can consider the advise of the others here that data validation where people are pasting into the area might be the wrong solution. Maybe stepping back might give another more simple solution.

Hi

My question is very clear. Previously you send one attachment (Validation.xlsm), in that you wrote a macro using controls. I want to know that process (macro coding and overall process).

thanks in advance.