Completed
Saving Files as Macro-Enabled
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
