Completed
Using Object Variables in a Sub Procedure
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel 2019 VBA Intermediate Tutorial
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 Introduction
- 3 Introduction to Expressions, Variables, and Intrinsic Functions
- 4 Variables - Overview, Naming Rules, and Conventions
- 5 Variable Declaration Methods and Scope
- 6 VBA Data Types
- 7 Option Explicit Statement and Removing Variables from Memory
- 8 Concise Ways to Declare Variables
- 9 Declaring Procedure Level String Variables and Reviewing Intrinsic Functions and VIN Characters
- 10 Assigning Values to Variables Using Intrinsic Functions and the Line Editor
- 11 Testing the Sub Procedure and Introduction to the With-End With Structure and the Offset Property
- 12 Creating a With-End With Structure that References the Offset Property and Testing the Procedure
- 13 Troubleshooting the Procedure and Re-Testing It
- 14 Saving Files as Macro-Enabled
- 15 Overview of MsgBox and InputBox Functions
- 16 Modifying an Event Procedure to Include a Message Box
- 17 Testing the Message Box Function
- 18 Modifying a Sub Procedure to Include an Input Box
- 19 Testing the Input Box Function
- 20 Overview of Object Variables
- 21 Using Object Variables in a Sub Procedure
- 22 Testing a Sub Procedure by Stepping Into It
- 23 Expressions, Variables, and Intrinsic Functions Recap
- 24 Introduction to Controlling Program Execution
- 25 Controlling Program Execution and Control of Flow Structures
- 26 Boolean Expressions, Logical Operators, and Comparison Operators
- 27 Overview of the If-Then Constructs
- 28 Using the If-Then-End If Construct
- 29 Creating a Function Procedure Using the If-Then-Else-End If Construct
- 30 Calling a Function Procedure from a Sub Procedure
- 31 Testing the Function Procedure and Modifying the Code
- 32 Creating a Function Procedure to Extract the Year from the VIN
- 33 Testing the Year Extraction Function
- 34 Creating a Function Procedure Using the If-Then-ElseIf-End If Construct
- 35 Creating a With-End With Structure for Concise Code - Testing Procedure
- 36 Select Case Overview - End Select Construct
- 37 Creating Functions Using the Select Case - End Select Construct
- 38 Creating Functions by Using a Text File
- 39 On Your Own - Creating a Function to Extract the Make
- 40 Testing Final Three Function Procedures for Extraction
- 41 Overview of Looping Constructs
- 42 Using a Do While Loop to Populate the Spreadsheet
- 43 Creating Procedures to Append and Clear Info on Sheets
- 44 Testing the Append and Clear Sheet Procedures
- 45 Avoiding Errors by Using an If-Then-Else Construct
- 46 Using the For-Each-Next Loop
- 47 Controlling Program Execution Recap
- 48 Conclusion
