Analyzing and REviewing VBA Code

[Cosmos75]

zilpher,

THank you for your input!

I have never found a tool that will tell me how efficient my code is, but there is one that will inform you of redundant lines, it's called mztools (http://mztools.com), is incredibly useful and will help you tidy up all those things you declared but never used.

Yes, I found that one and the Procedure Caller feature is WONDERFUL!

I'd recommend that once the requirements are understood, a Functional Design is carried out next, no code, just a "when this happens, do this, this and this" type of document, once that is agreed a detailed design should be done with a list of all functions, objects, properties and methods etc that will need to be created.

This particular project was more of, First X, then do Y, then do Z. So, that's kind of how I started writing the code.

Finally, having another developer to do a code review can be really useful too, it's something we do at work and can help a lot. I don't know how many lines of code you have, but you could try stepping through the code in debug and manually reviewing it yourself.

I wish I had that luxury of another developer to review my code but it's just little ol' me with what scattered VBA knowledge I know!

I found more free tools for VB but not too many for VBA. It was the same even when it came to tools you had to pay for.