VBA SIG

Hosted by: Ron Dunbar

Visual Basic for Applications (VBA) is a powerful tool for leveraging the considerable capabilities of Excel. An effective VBA subroutine can automate many tasks that are otherwise tedious and error-prone, or require more skilled personnel to execute. In this SIG we will go through VBA subroutines ("subs") line by line to see how they are constructed and how they work, and to learn the basic concepts of this "object-oriented" programming language. In so far as possible, the subs will be selected from real life applications. Like any language, foreign or computer programming, VBA has a steep learning curve and requires a lot of study and practice to master; 90 minutes or so once a month is only the beginning.