Missing occurence for IF statement

[rakotonirinas]

Hello,

I've got the following vba code, which purpose is to paste the content of a userform to a worksheet. However, the code checks first if no duplication exists. If it finds duplication, then it gives a message box warning, to which case the user can either cancel or continue.

The issue I have is that I think I'm missing a piece of statement which action should be similar to the one if the answer is yes from the duplication warning, i.e., if there is no duplication at all, then ... (it looks to me that this is missing but unsure where to put it).

I'm hoping you can assist and enlighten me.

Thank you so much.

Please Login or Register  to view this content.

[CheeseSandwich]

This line:

Please Login or Register  to view this content.

Is easier to understand as:

Please Login or Register  to view this content.

With that in mind the above if would need an: Else

See below:

Please Login or Register  to view this content.

[DMA]

Please Login or Register  to view this content.

[rakotonirinas]

Thank you. Would I be right to suggest then that I will have to re-write the same code as if the answer to the duplication to continue is Yes, that is,

Please Login or Register  to view this content.

So this will be duplicated in the whole code. I hope what I'm saying makes sense

[DMA]

If I understand your question, the answer is no.
In the area after "Else" you simply write what you want to do if there's no duplication.

[CheeseSandwich]

The below line will only fire if there are duplicates:

Please Login or Register  to view this content.

If there are no duplicates then it will go to:

Please Login or Register  to view this content.

The way I see it: It is offering to still run code if there are duplicates (Yes/ No), if there are no duplicates then it would not need to ask about duplicates?

[rakotonirinas]

That's correct indeed. So if there is no duplicate then values in the userform will be copied straight to the worksheet, similar to if the answer to the duplicate question was Yes. the purpose of the duplicate check here is just to alert the user that an entry already exists for the same unique value.

Therefore, my question is, should I just re-write the same code as if I was answering to Yes to the duplicate check (since there was no difference between the two except one alerts that there is duplicate entry)? If so, is there any way I can simplify the process without re-write the same code twice?

[CheeseSandwich]

Hmm not sure I fully understand, is it something like the below:

Please Login or Register  to view this content.

[rakotonirinas]

Exactly what's I'm look for. Thank you so much.