Go to found duplicated row and show MsgBox with options

Hi Excellers,

I have made a UserForm where the user will fill in the data. Upon clicking SAVE, I would like to find the possibility of duplication and provide options of what to do next.

I would like to learn how to code a VBA that will perform these actions after the SAVE button is clicked:

1. Detect for duplication only in column E:E
2. Pop up another UserForm to compare the details between the original record and the new record (data migrated from first UserForm)
3. Keep Original Record
4. Replace Original Record

Much help will be appreciated! Below is my first UserForm's code:

Please Login or Register  to view this content.

Bumping...