|
First, you need to post your code. Some of us can't debug in the dark. Second, it sounds like you are jumping into this with too little up-front design. Thinking it through first is going to make it easier on you in the long run.
Not everybody agrees with my constant use of UML, especially the Use-case analysis, but I started back in the '60's where the process was "build a flowchart and the code (assembler at that time) becomes intuitive." I spend many hours trying to fix the wreckage of Poorly-designed projects. (Many times, these were supposed to be one-time use, and pounded out under pressure.)
If you are under pressure, use a tool that already has what you need, like Visio. You can make VBA apps that will put Visio through hoops that you will never accomplish starting from scratch.
Mike
|