3799. A Quick Start Guide to Using Excel VBA

Paper

Abstract

MS Excel is a tool that just about every engineer has on their desktop PC.  Visual Basic for Applications (VBA) is a very powerful feature included in MS Excel that most users don’t use.  It was first introduced in MS Excel in 1995 and over the years has become even more powerful.  In this paper, I will review useful programming commands, ways to speed up processing of data, and provide a few examples of use.