Ok vb code for User Form does not work, it save data info wrong

I'm having trouble with my user form. When I enter new data and save it, the surname doesn't get copied to column Z like it's supposed to.
Even when I add a new main member and two other members, the surname still doesn't copy to column Z. Then, if I add another new main member and members,
it replaces the first non-main member and adds the new members below it, so I end up losing the two members I added before.
It seems like there's an issue with copying the surname to column Z.

Please Login or Register  to view this content.