How to write code to restrict the copy-paste if sheet is having more than one drop-down?

Hi

I have total 4 drop-downs in my sheet A column - Resource Designation , B - User Type, C - Organizational Unit and D - Country.

Previously I have posted my question here for one drop-down Resource Designation. I got the below code from the Forum.

I am trying to change the code for the other three drop-downs as well but getting some errors not code wise but not working as expected.

Can you please help me in combining the same code to work for all 4 drop-downs?


Thanks
Mounika

Please Login or Register  to view this content.

Hi
Thanks for the reply , but i don't want to disable the paste and copy in my sheet. I just want to pop-up an error message whenever user paste the wrong value in the drop-down. Please find the attached sheet for example , it's already having the code for Resource Designation drop-down , it has total 3 values Clerical, Manager,Professional. If i paste say clerk ,it will throw an error saying please select correct value from drop-down.


I need the similar functionality for remaining drop-downs User Type, Organizational Unit and Country.

But when i used the same code with variable change and range changes, it is not working as expected.Please help me to get through this.


Thanks for the continuous help from the forum members.

Hi

can you please check with other forum members please...


Thanks
Mounika

hi timmu, if your data validation range is A1:D1, option with message and clearing content of the wrong validated cell value

Please Login or Register  to view this content.

Hi watersev,

Thanks for your valuable suggestion!!

Actually my range is very large it includes A1:A500 , B1:B500 , C1:C500 and D1:D500. So , I created a Named Range called ValidationRange that includes all these .

The code is working fine but my concern is if we copy in bulk suppose from A10 to D14 then we will get the error message pop-up 24 times and in case of huge bulk copy pop-up will pop 500 times which is not user friendly , so i used the code you said earlier like below:

Now ,it is popping up only once just giving the First cell address i.e.., A10 but not the remaining , is it possible to modify this code further to make it user friendly .. please let me know if we can , thanks for the help.

Please Login or Register  to view this content.

Please Login or Register  to view this content.