Download Update: VBA and Excel…Part 2
Uncategorized
GeoPrac.net Sponsors
GeoPrac.net wishes to offer our sincere thanks for the support of all our sponsors. Please be sure to check them out and let them know you saw them on GeoPrac. And if your business is […]
Rockman's Ramblings
Most Popular GeoPrac.net Content of 2007
Happy New Year to everyone! Most blogs this time of year publish a list of their most popular content from throughout the year. I thought it would be nice to do the same hear on GeoPrac. So, without further adieu…
The most popular GeoPrac.net GeoNews and Article Items of 2007 (in order of popularity) are…
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.