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...
Patrick2788
Silver Contributor
Thanks for catching that one.
I feel silly:
(I've replaced the workbook previously uploaded)
SergeiBaklan
Jun 27, 2022MVP
Now we are in sync
- Patrick2788Jul 02, 2022Silver ContributorThank 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