Software testing is a important part of software development.
During earlier tests at the end of the software development cycle as an acceptance condition, today's approach is to write the test before programming the logic of the application (TDD).
Many actual programming languages provide appropriate tools for automated test execution.
The VBA programming language unfortunately only contains rudimentary functionality to test the code (Debug.Print, Debug.Assert).