Hi Marty
there's always gotta be some dissent ...

Avoid Public variables in favor of classes even if that class contains nothing more than a few Boolean properties.
There is nothing wrong with using pub vars if u keep them organized and to a minimum. updating a pub var is much much quicker than using a class.

Always use Case statements instead of multi-level If-Then-Elses
I agree with this for code organization.. but if the statements are in a time critical loop or such then go for the If Thens which again are much faster.

My firm belief is that you should start with an organised structure for your program... everything in its place. You will develop clean code, reusable code etc and never feel overwhelmed as your program grows.

And re comments... i think that it is best to describe (in normal words) what is going on in a sub rather than just commenting each line. It may be obvious to you now why variable X is updated from Y to Z but what is the point of it in the broader scheme of things...

Regards
Stuart