Inserting info to table with userform based on unique number

I'm posting my first thread on this forum after viewing a lot of threads.

I created a potential database, I want to have our agents add sold equipment data in a different sheet with the help of a userform. The userform ask for IMO number (unique boat number) the sold equipment (3 options) and some other not relevant questions.

If they click enter on the userform the data is entered in the table/worksheet. This all functions well BUT I don't want that the agent creates a new line for an IMO which was already entered.

Instead of
IMO 1 - TRUE - FALSE - TRUE
IMO 1 - FALSE - TRUE - FALSE

I would like to have the information added to the line
IMO 1 - TRUE - TRUE - TRUE

I've managed to insert a pop up message if the IMO was already entered in the database. This means that one or 2 pieces of equipment are already entered in the table. The pop up alerts the user on this fact.

Is it possible to have the userform change the data if it's FALSE and the userform states TRUE but if the data is already TRUE, that its left that way?

If created the following code with the help of the treads I've read so far.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Please Login or Register  to view this content.

Thanks a lot already!