So easy to follow! Thank you! I was designing a user form at work and I needed this feature. Appreciate you!

Very good example. Thanks for posting.

Hi thanks for the video explanation. I have one question. I have two fields collecting year and month respectively, can I create a formula with these two sets of conditions, to give me unique records and avoid duplicates or should I redesign my form? Also, if I am trying to avoid duplicate months, how would I do that as the unique code is for days? Thanks for any explanation and keep up the good work.

Welcome Thank you very much Excellent and clear explanation I have a question I hope you can help me. I have a problem that I could not solve. The problem is as follows (duplicate data): I have created a database in VBA. And I worked in it a button to search, a button to save, a button to query, a button to edit, a button to open a file, and a button to exit. The problem is that the data gets duplicated from the edit button. As for the data save button, I used code to not duplicate the data and it worked and no longer accepts any duplicates. The recurrence occurs from the modification button when I query the data of an employee who already exists (i.e. whose data has been previously entered), and I modify his data with the same data of another employee who is also present in the same database. It saves the modification and migrates the data to the sheet or database, the data duplication occurs and this is the problem I'm having. I used the no-repeat code I used for the save button But it didn't work properly Please help me

I tried to use this and re-modify the code for my own use. Very helpful!! however, i have so many rows 400+ in count and it lags when the code are executed. So I always break the vba while running. Can you please help how to prompt the message box to display if the code has been added already into the worksheet?

Thanks for your brilliant performances. Now i want to know one issue that, Date wise data entry if any date missing give me message that previous date data is missing. Is it possible brother.

HI there, thanks for your reply. But i still cannot understand how does it check that order ID 1009, is not repeated ?? Do i make sense , sorry. Thanking you in advance. kind regards. martin

Just a doubt. at line 13 you are saying if some order id exist 3 times then it will count. but this form will accept only unique values hence explanation is incorrect and instead a=a+1, we can put a=1 and test the conditions. BTW I liked series

Hi there. Thanks for the tutorial on duplicate entries form. I fail to understand the logic, because it seems u r checking for which is the next