validation rules not working when someone copy paste data on validation cell

hello jthakrar,

welcome to the forum.

Data validation in a cell only applies if data is entered manually into the cell. Any cell with data validation can always be circumvented by a paste operation. If you want to really foolproof the possible data entries, you'll need a VBA macro solution.

If you can post some details about the validation requirements, I'm sure someone here will come up with the required code.

cheers

the code I posted was for another thread, I apologize.

***************************************

Antonio,

this is a fine macro, but I'm not sure that this thread is at a point where such a detailed suggestion is suitable. We have not even learned what kind of validation is required, nor for which cells. Also, a macro solution would probably need to be based on a Worksheet_Change event rather than a standard module sub to ensure that no invalid data can be entered into a given range of cells.

This requires more information from jthakrar before any valid suggestion can be made.

cheers

Yes, you are right, I appreciate your suggestions.

I'm sorry, the code I posted was for another thread, I apologize for my error!

Regards,
Antonio

the code I posted was for another thread,

... the pitfalls of tabbed browsing.

It happens. Thanks for clearing it up.

Good morning jthakrar

A lot of problems that users run into (but not all) are usually solved by some clever bod somewhere along the line and posted for the world to marvel over. One such technique is posted here by John Walkenbach here and is both fantastically clever and simple.

Read it and marvel at your liesure.

HTH

DominicB

Nice tip, Dominic!