Some steps I would recommend:

Make sure every control has a different name. Rename any with names like
Button17 to btnOpenTheNewForm or something.

use the onclick event for the button to call a sub which is not an onclick for
another button. i.e. use the onclick subs only to call another sub or run a
one line command. Do not fill them with other stuff. This is called
Modularising your code.

Use separate modules for general code rather than putting it in the sheet or
form code modules.

If you structure your code in this way it will help  you to build and maintain
reusable code which saves a lot of time in the long run.