Shorter VBA code, help

Hi!

Can anyone please help me write a shorter vba code?

This vba code I need for editing futsal players records.

That vba code works well, but it's too long.

The code below is for 2 teams, but I have in league 10 team, so I would like a better solution.

Thank you in advance for your help.

Kind Regards
--Daniel

Snap 2017-11-23 at 12.15.24.png

more in enclosed files

Please Login or Register  to view this content.

Thank you for help, I know how this code extend for the other teams.

This vba code do something what is undesirable, but I cannot modify it...

For example, If you delete text from the txtBox 9 and 10 after that save with CommandButton1, so in sheet2 will be added player with duplicate values (name and date).

In my veryyy long code it worked well.

Do you know how to fix it? - for adding players and deleting players?

Originally Posted by xlnitwit

Hi,

You could replace your code with this

Please Login or Register  to view this content.

Hopefully you can see the pattern to extend the code for the other teams.

Thank you for help, I know how this code extend for the other teams.

This vba code do something what is undesirable, but I cannot modify it...

For example, If you delete text from the txtBox 9 and 10 after that save with CommandButton1, so in sheet2 will be added player with duplicate values (name and date).

In my veryyy long code it worked well.

Do you know how to fix it? - for adding players and deleting players?

Originally Posted by xlnitwit

Oh, I didn't see the Worksheet_Change code you have. Change the output routine to clear the range as your old code did

Please Login or Register  to view this content.

Thank you very much.

Thats final code...

Please Login or Register  to view this content.