Autoplay
Autocomplete
Previous Chapter
Complete and Continue
Excel 2021 VBA Intermediate
Exercise Files - Download Before Starting the Course
Exercise Files
Course
Introduction (1:48)
Variables, Data Types, and Intrinsic Functions (2:17)
Introduction to Variables (5:21)
Reviewing Project Explorer and Creating New Modules (2:51)
Creating Sub-Procedures and Declaring Procedure Level Variables (3:10)
Intrinsic Functions (2:31)
Assigning Values to Variables Using Intrinsic Functions (7:43)
With-End With Structure and Offset Property (3:13)
Assigning Variable Values Using With-End With Structure (2:15)
Testing ParseVIN Procedures (0:50)
Message Boxes (4:36)
Input Boxes (0:47)
Creating and Testing Message Boxes in Event Procedures (6:39)
Creating Input Boxes by Modifying Existing Procedures (7:44)
Testing Modified Procedures (0:59)
Introduction to Object Variables (1:14)
Declaring Object Variables in Sub-Procedures (9:06)
Testing Object Variables by Stepping Into Code (5:21)
Variables, Data Types, and Intrinsic Functions Recap (2:00)
Controlling Program Execution (0:58)
Control Structures and Conditional Branching (7:55)
If-Then-End If Construct (3:34)
If-Then-Else-End If Construct (7:26)
Rearranging Code and Creating Function Procedures (6:12)
Testing Rearranged Code and Function Procedures (0:38)
Setting With-End With Structure in Calling Procedures (7:19)
Select Case and End Select Construct (0:39)
Select Case Statement (3:00)
Creating Function Procedures with Select Case Construct (2:16)
Using Text Files to Insert Function Procedures (3:17)
Looping Constructs - Do Loops (2:16)
Modifying Procedures to Include Do While Loops (3:21)
Sub-Procedure to Select, Cut, and Paste to Other Sheets (3:54)
Creating Procedures to Clear Sheets and Call Procedures (3:35)
Looping Constructs - For Loops (0:48)
For To Next Loop and Encountering Errors (2:46)
Investigating Cause of Error and Fixing It (5:39)
Creating and Testing For Each Next Loop (3:24)
Controlling Program Execution Recap (0:49)
Conclusion (0:09)
Creating Sub-Procedures and Declaring Procedure Level Variables
Chapter content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock