Technical articles about geotechnical engineering, engineering
geology, hydrogeology, geophysics, geoenvironmental and related fields.
Interested in publishing here? We encourage contributions in all
disciplines! Read more about submitting content on GeoPrac.
VBA and Excel for Engineers and Scientists – Part 2
In this long awaited second article in the series, I will dive into the meat of the VBA programming language, including code containers, data types, variables, math operators, built-in functions, flow control, and even debugging.. In the end, you should be able to code some fairly complex things including custom worksheet functions that you can use in your spreadsheet just like a regular formula. Also in this article I give you a sample spreadsheet with some useful utilities that you can use right away.