But whenever I moved the focus to another row, Row Leave is called first before Cell Leave/Cell Validating.
Is there another way of validating the cell when leaving a row?
Canceling this event cancels the changes to the current cell.
When this event is canceled in data-bound mode, the new value is not pushed to the underlying data source.
This doesn't prevent users from pasting invalid data in the first place, but results in the immediate revocation of invalid data, which might be close enough to the same thing for your purposes.
So how can i protect to user can't enter wrong data or outside from my validation list.B) Excel only performs validation on single cells and not on paste actions. I can solve problem A for you; I think you will need VBA to do custom validation for problem B.