Q:

excel vba how to unit test vba code

Use Rubberduck:

https://github.com/retailcoder/Rubberduck/wiki/Unit-Testing
2

New to Communities?

Join the community