Continuing on a project... 2

[VBAva]

Hello all

I am looking for a little advice...
I am working on a VBA application at the moment but will be finished with it in a few weeks.
The application will need to be changed later as the requirements change, but by a different programmer.
I have quite a lot of comments in the code but it is still quite confusing at times.
I have also done out a bit of a summary, outlining the different subs, forms and functions and where they are used.

I have never been in this situation before where someone else would continue on a project that i started and would like to know if anyone has experience with this and how i could make it as easy as possible for the next programmer to know exactly what is going on.

i will not be available for them to ask questions unless it is a real emergency.

any suggestions would be very welcome

Thank you
Ava

 

[Jooky68]

It sounds like you have done pretty much all you can do. You can add all the comments you want, the new programmer is still going to have to step through the program and get used to the flow and logic of it. No two programmers are a like. Unless there is only particular sections that need to be changed becuase of this "requirement" change, which you should pinpoint this and try to explain the logic if possible. But it sounds like there is going to be a complete overhaul of the program, in which there is nothing you can do. The programmer just needs to get in there and spend sometime with it.

 

[Alan111]

If individual lines of code are already commented, then a good flowchart will give an overall picture. Even a handwitten drawing can summarise and simplify complex problems.

 

[VBAva]

Thank you,

This might be helpful to others so i gave you both a star