Curated Video
Excel VBA Programming The Complete Guide - Unload and Hide a UserForm
There are two ways to "shut down" a UserForm: unloading, which clears all of its data and hiding, which hides it from the screen but preserves the user's inputs. In this lesson, we wire up our two Command Buttons to utilize these two...
Curated Video
Excel VBA Programming The Complete Guide - Comments
In this lesson, we'll explore the benefits of comments to the developer and practice writing them in the context of a procedure. This clip is from the chapter "The Visual Basic Editor" of the series "Excel VBA Programming–The Complete...
Curated Video
Excel VBA Programming The Complete Guide - The InputBox Function
In this lesson, we use the InputBox function to collect a new worksheet title from the user. The InputBox is a basic dialog box with a single text entry field, a prompt, a title, and OK / Cancel buttons. This clip is from the chapter...
Curated Video
Excel VBA Programming The Complete Guide - The String Data Type
A string is a collection of characters --- in layman's terms, it's just text. In this lesson, we take a look at VBA's support for two types of strings -- variable-length and fixed-length -- as well as the advantages of both. This clip is...
Curated Video
Excel VBA Programming The Complete Guide - The Formula and FormulaR1C1 Properties
In this lesson, we introduce a basic sum example to show how R1C1 notation can be helpful when duplicating formulas across multiple columns. This clip is from the chapter "Range References" of the series "Excel VBA Programming–The...
Curated Video
Excel VBA Programming The Complete Guide - Submit the UserForm
In this lesson, we wire up the final Command Button on our UserForm to capture the user's input and populate it on the spreadsheet. This clip is from the chapter "User Forms" of the series "Excel VBA Programming–The Complete Guide".null
Veritasium
Magnetic Micro-Robots
Magnetic micro-robots aren't just really cool, they have some potential practical purposes. An episode from the Veritasium introduces learners to the micro-robots and their possible future roles in biomedicine. Actual footage of the...
Annenberg Foundation
Annenberg Learner: Thinking and Communicating Like a Biologist
The goal of this seven-day unit is to look at the big ideas in science literacy. This video on how to think and communicate like a biologist is the first lesson in the unit. [7:23]