Programming Directly in Excel Using VBA (ChEn 263 - Lecture 23, Part I)

This video contains part I of a lecture for Chemical Engineering 263 (Undergraduate Numerical Tools) at Brigham Young University. In the lecture, I introduce Visual Basic for Applications (VBA). We talk about
(1) How to record a simple macro, and
(2) How to program a basic function in VBA
There is some supplemental material that accompanies this video, including some example spreadsheets:
- www.et.byu.edu/~treedoug/_pag...
And a handout reviewing VBA's syntax:
- www.et.byu.edu/~treedoug/_pag...
There is a part II to this video ( • Integrating Excel and ... ) that discusses how to integrate Excel with Python using XLWings.
More resources related to this lecture can be found at: www.et.byu.edu/~treedoug/teac...