Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

vba code structures

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » VBA code structures - question for Anthony

VBA code structures - question for Anthony

ResolvedVersion 2007

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

Wed 23 Jun 2010: Automatically marked as resolved.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

Convert A Form Into A Report

If there is a form that you want to to save as a report:

1. Open that form in Design View
2. Select File and Save As
3. In the Save As Dialog box Select Report

The system creates a report based on the form.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.