VBA for data validation on copy / paste

hi friends

with the help of one of the members here, i've been able to implement data validation on multiple cells (http://www.excelforum.com/excel-prog...ple-cells.html)

i want to preserve this validation even when the user copies & pastes the content from another excel. currently the validation works during the data entry mode only.

im told it is a limitation of excel (copy/pastes over rides any validation on the cell), though it can be achieved via VBA.

if anyone has come across any code which accomplishes this, please let me know. i've been after this for a while now.

thanks.

You will have to write the code in Worksheet_Change module which would check for data entered in any way (typed or copy-pasted) & if the data doesn't comply with the mentioned conditions, it wouldn't accept & you can choose to give a Validation error through a message box.

If you are not good with coding, attach the file & mention the conditions & I would write it for you.

Regards,
Karan

hi karan. thanks for looking at it. i've attached the excel sheet here. i've done very little coding in VBA before. but this is way out of my reach. regards.

Use this code in the Sheet Module:

Please Login or Register  to view this content.

Refer the attached file. Don't forget to enable macros.

Regards,
Karan

thanks a million karan
that looked so easy to do, after you coded it.
really appreciate it.
good luck.