Forum Discussion
Patrick2788
Jun 25, 2022Silver Contributor
A LAMBDA Exercise
For this exercise I stripped down a calendar template and put in some sample data. The goal is to obtain gross pay for July for 3 employees. The data arrangement: I believe there are seve...
SergeiBaklan
Jun 27, 2022MVP
Now we are in sync
Patrick2788
Jul 02, 2022Silver Contributor
Thank you for sharing. The way you approach this task is fascinating. The way I was taught to write code in VBA is avoid lengthy modules and split subroutines in smaller tasks and simply call them in another macro. Your LAMBDAs are like a quality Dutch coffee maker. If one part needs to be removed or replaced, it's easy to do so. Additionally, I do like the parameter names like 'vector' instead of single 'x' or 'y', for example.
- SergeiBaklanJul 02, 2022MVP
Thank you, I only try to follow general principals
1) engineering - avoid to combine few functions in one module, that decreases reliability and maintainability
2) coding - function shall be self-explainable to avoid comments as much as possible