Download Update: VBA and Excel…Part 2
Rockman's Ramblings
GeoPrac Turns Two!
GeoPrac.net is now well into its toddler years! Today marks the second anniversary of the site. The past year has seen a major upgrade to the content management system, a new design, Geothreads, Delicious geotech, […]
Uncategorized
Special Features
Besides the news and articles that we publish here on GeoPrac, there are a few other items that don’t fit in any of the other menus. We refer to these gems as “Special Features”. Downloads […]
Articles
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.