I'm looking for opinions here. The question is this:
How would you arrange your code in the following scenario?
A VBA project is written to perform a task.
It includes 5 procedures (none are Private).
It includes 3 functions (none are Private)
It has no forms.
At it's most complex point, the call stack is 3 procedures deep.
The first function called is used in the top layer of the stack,
the second function is used in the 3rd layer of the stack,
the third function is used as a test in a procedure that "stands alone"
(it is never called from any of the others).
I realize that the macro will run as long as all of the requisite code is in the project, I am wondering from a best practices / ease of understanding for other subsequent coders perspective how anyone here would arrange the work. I realize this is a generic example but I was curious.