Completed
Looping Constructs - Do Loops
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
