Uploaded October 2024 | Updated September 2026, 1 week ago

---

The only video in the second series on Excel. See the entire bootcamp here: learncheme.com/bootcamps/excel-bootcamp-1

0:00 Introduction
1:31 Excel settings for use of VBA
4:43 Excel and the visual basic editor
9:02 VBA - exchanging information with "Spreadsheet World"
10:55 Ways to run a sub
14:53 Reading a sub as a macro
34:55 The macro recorder as a code detective
39:15 User-defined functions
52:05 VBA program structure elements - selection
1:16:24 VBA program structure elements - repetition
1:38:26 Working with arrays in VBA
1:51:51 VBA details

Made by David Clough, professor emeritus at the University of Colorado Boulder, Department of Chemical & Biological Engineering.