Error in userform excel

[asem1967]

Hello

I have userform as in attached need to correct in code, when I run userform and when I add in name as example RM05 in location as many equipments in this location I need to show in this form, and after I press button change it will give error as attached that this record already exists and repeat. My question how I can accept to change in equipment ID (eqpt id) for one cell without giving this error message.

Regards,,

userform.jpg