How can I avoid duplicates based on multiple cells with Userform VBA?

Hello everybody,

I need to insert data in a worksheet by use of a Userform. Before the data is inserted I need to check if multiple cells already contain the data I have in the Userform. In my case a duplicate is such only if all the given cells contain the same data. These cells are A, B,C, D and E

This is the code that I use to insert the data in the worksheet. As you can see I have tried using Countif and Countifs but with no success

Please Login or Register  to view this content.

Thank you for any help

Hello Mehemtcik, thank you for the prompt reply.

I would like to use the formula in VBA, when I press the NewEntry button. How can I add that in the vba code?