rocket head

I need to get this thing done so I should probably just scratch some lines and boxes in my notebook, but I am anal and I want to do this the "right way." My "program" is basicaly a collection of VBA modules embedded in an excel workbook. The modules serve as a kind of procedural generation aspect of the excel program. The user inputs some initial state data and when the modules run the spreadsheet calculates a series of output states. My question is, how should I draw the flowchart? Specifically what kind of boxes, arrows ect should I use? Is there a software that can make neat looking flowcharts? How do I use it?

InfoGeek

First of all, flow charts are drawn to specify the logic of a program in a graphical manner. These are language independent and drawn prior to writing the program. But you are trying to go backward and draw a Flow Chart from the program. This can be done manually and you can use MS-Word or Powerpoint or any other drawing tool, but I don't know of any tool that can generate flow chart from a VBA module. Search google, you may be lucky.

__________________
PFO - My daily dose of technology.

zorin

You can use smart draw to draw flow charts, theres a free trial here. Much more easier that drawing them by hand.

rocket head

Thank you. Is there any kind of format I should follow?

Ooble

The standard flowchart formatting should be fine for most any flowchart you'll want to draw:

http://en.wikipedia.org/wiki/Flowchart

However, I think a data flow diagram would be more helpful in this case:

http://www.smartdraw.com/tutorials/software-dfd/dfd.htm

__________________
Me :: You :: Them