Completed
Creating Pivot Tables by Recording a Macro
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel 2019 VBA Advanced Tutorial
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 Introduction
- 3 Introduction to Forms and Controls
- 4 UserForm Object-Controls-Properties-Events-Methods
- 5 Reviewing Types of Modules and Inserting UserForm Objects
- 6 Changing Form Properties
- 7 Creating a Label Control and Adjusting its Properties
- 8 Copying a Label Control to Create a New One
- 9 Adding Two Text Box Controls to Forms
- 10 Adding Two Command Button Controls to Forms
- 11 Adding a Combo Box Control and Label
- 12 Adding Two Frame Controls with Three Option Buttons in Each
- 13 Adjusting Option Button Properties
- 14 Aligning and Grouping Form Controls
- 15 Testing and Adjusting Form Tab Order
- 16 Coding the Combo Box to Display Months
- 17 Coding Other Form Controls Using Text Files
- 18 Reviewing Coding in Text Files
- 19 Displaying the Form Programmatically
- 20 Forms and Controls Recap
- 21 Introduction to Pivot Tables in VBA
- 22 Introduction to Creating Pivot Tables
- 23 Creating Pivot Tables by Recording a Macro
- 24 Creating Pivot Tables
- 25 Testing CreatePivot Sub-Procedure
- 26 Creating Sub-Procedures to Set Pivot Table Fields
- 27 Finalizing Forms
- 28 Creating Sub-Procedures to Code Options in the Period Frame on Forms
- 29 Reviewing GetLastDate and GetFirstDate Code Blocks from Text Files
- 30 Coding Options in the Sales Frame on the Form
- 31 Reviewing Text File Procedures - ConsolidateData-GrabCells-FinishReport
- 32 Completing Code Modifications for Form Objects
- 33 Testing Completed Forms
- 34 Adding Icons to the QAT to Run the Form
- 35 Pivot Tables Recap
- 36 Conclusion
