Hi, Mr. JE McGimpsey
Thanks for your answer. Please there is more small thing, if I want to find
or stop duplicate in more than one sheets e.g like data in different month
but with same serial employee number and each month in separate sheet, so I
want avoid duplicate of employee number in all sheet.
I will more appreciate if u can help in this mater.

"JE McGimpsey" wrote:

See

http://cpearson.com/excel/NoDupEntry.aspx

In article ,
Alam wrote:

If I made any duplicate while data entry for number or text, I want MsgBox
warning for duplicate, and in the same time to cancel event after pressing
ok. Please I want help in this matter I will be very appreciated.
Thanks