Michael has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course
VBA code structures - question for Anthony
Anthony
During last weeks training you mentioned that there are tools available to convert existing code (or parts of code) into a decision tree. Can you point me towards some of these?
Many thanks
Michael
RE: VBA code structures - question for Anthony
Hi Michael, thanks for your query. Have a look at this:
http://www.dailydoseofexcel.com/archives/2007/12/13/vba-code-documenting-tools-project-analyser-and-visustin/
Obviously, I wouldn't recommend spending vast amounts of money for a licence, but this is an example of what can be done, if nothing else when you are teasing out the logic of you code. Also Google the key words in the article, there are freeware versions of similar software out there.
Hope this helps,
Anthony