Microsoft Excel VBA Function Programming (BETEC010)

Course | December 12 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell

 Human Resources

"This course details the process by which custom, user-defined functions are created using the Visual Basic for Applications (VBA) programming language. Once defined, VBA functions may be used in Microsoft Excel to produce custom calculated outcomes that extend beyond the capabilities of the standard Excel function library.

Learning Objectives

* Understand the VBA Project hierarchy and relationship to the Excel host application.
* Identify the elements of the Visual Basic Editor interface.
* Create and manage Modules within a Project.
* Understand the code structure of Procedures.
* Use correct VBA syntax keywords and operators.
* Test statements using the Immediate Window.
* Code user-defined functions and related arguments, variables, or constants.
* Create decision structures to enable branching of code sequence.
* Reference user-defined functions within Excel workbook files.
* Recognize effective programming techniques to promote code legibility."

 ksamsell@berkeley.edu