I have nothing against VBA, actually. For those that use Excel day-to-day, they'll definitely gravitate towards VBA.
However, as a practicing Engineer with access to Matlab, I didn't use VBA too much (once every ~4mo as project required). Since VBA has a huge API, I personally found myself...
Inspired by the book "Excel for Scientists and Engineers: Numerical Methods" by E Joseph Billo, I created an open-source engineering template, once and for all. No prepackaged calcs here, just pure numerical functions (Newton, ODE, etc) to build upon.
Also, the template includes an interesting...