unit testing code using vba
 

Not a new idea, but I haven't seen anything out there that has worked for
me, so I built some classes to facilitate unit code testing. It works for a
given module, but now I'd like to apply the same idea to the project.
Strategy I'd like to figure out how to implement is:
1) common Public name in code module to test, "zTestSuite"
2) add test dedicated module to project, "zUnitTest"
3) get a collection of all codeModules
(Application.VBE.ActiveVBProject.VBComponents)?
4) runt the procedure if present, skip if error (Application.Run??)

Obviously half-baked still, but I'd rather not invent a wheel if it's out
there? Anyone doing anything solely with VBA that is quick and effective?

Thanks! Eric