Request for tips and notes for code structure and style

[arnoldasz]

Hello,

I would like to get any tips and notes for my VBA project structure and coding style as I want to learn to write understandable and clean code. I am also interesed if there are any unnecessary actions or critical mistakes (or things that should be avoided) in my code.

It would be great if I get any comments from you.

You can access my project files with following link:

https://github.com/arnoldasbud/VBAMenu

[Paul_Hossler]

Why not just make a workbook with what you'd like comments/suggestions on and attach it here?

Although there are lots of personal styles -- the key word being 'personal' -- some approaches are more appropriate than others depending of the project and user base






https://thoughts.brunobernardino.com/write-code-for-humans-not-machines/

https://www.joelonsoftware.com/2000/05/09/the-process-of-designing-a-product/

https://www.joelonsoftware.com/2005/05/11/making-wrong-code-look-wrong/

[arnoldasz]

Thank you for links. I have attached workbook in this post.