excel vba tool to help with refactoring code

HTML
Use Rubberduck:

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

Source

Also in HTML: