[RESOLVED] VBA class diagrams?

Hello there,

I've finished my stint on an internship program automating the ms access database to generate questionnaires.

i'm required to present the class diagrams of the project on 'judging day' but i havent been able to find any examples off the Internet to draw up class diagrams for VBA.

Also, being technically inferior (still), i doubt i have any classes.

All i have is a couple of 'Forms' & events (e.g list_click, list_dblclick, command_click) and what not.

The easy way out would be having a software which generates the class diagrams by pasting all the codes. (havent been able to find any of that either?)

can someone please enlighten me? =)

Thank You

Astro

You may be looking for a type of code analyzer that may have a diagram feature. For the database you can diagram its schema (reverse engineer type of diagram) using Access menu - Tools > Analyze > Doocumentor...

i thought it'd be only nice that i sort this.

download 'visual uml'

go to the embedded ide for vba within the ms office tool (ms access)

export each forms (to .cls)

open up visual uml (create new model & etc...)

select visual basic

proceed to 'reverse engineer' > files

open up the .cls files that you've exported

and your model is up!


Astro