Completed
Start
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel 2021 VBA Intermediate Tutorial
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 Introduction
- 3 Variables, Data Types, and Intrinsic Functions
- 4 Introduction to Variables
- 5 Reviewing Project Explorer and Creating New Modules
- 6 Creating Sub-Procedures and Declaring Procedure Level Variables
- 7 Intrinsic Functions
- 8 Assigning Values to Variables Using Intrinsic Functions
- 9 With-End With Structure and Offset Property
- 10 Assigning Variable Values Using With-End With Structure
- 11 Testing ParseVIN Procedures
- 12 Message Boxes
- 13 Input Boxes
- 14 Creating and Testing Message Boxes in Event Procedures
- 15 Creating Input Boxes by Modifying Existing Procedures
- 16 Testing Modified Procedures
- 17 Introduction to Object Variables
- 18 Declaring Object Variables in Sub-Procedures
- 19 Testing Object Variables by Stepping Into Code
- 20 Variables, Data Types, and Intrinsic Functions Recap
- 21 Controlling Program Execution
- 22 Control Structures and Conditional Branching
- 23 If-Then-End If Construct
- 24 If-Then-Else-End If Construct
- 25 Rearranging Code and Creating Function Procedures
- 26 Testing Rearranged Code and Function Procedures
- 27 Setting With-End With Structure in Calling Procedures
- 28 Select Case and End Select Construct
- 29 Select Case Statement
- 30 Creating Function Procedures with Select Case Construct
- 31 Using Text Files to Insert Function Procedures
- 32 Looping Constructs - Do Loops
- 33 Modifying Procedures to Include Do While Loops
- 34 Sub-Procedure to Select, Cut, and Paste to Other Sheets
- 35 Creating Procedures to Clear Sheets and Call Procedures
- 36 Looping Constructs - For Loops
- 37 For To Next Loop and Encountering Errors
- 38 Investigating Cause of Error and Fixing It
- 39 Creating and Testing For Each Next Loop
- 40 Controlling Program Execution Recap
- 41 Conclusion
