Excel 2019 VBA Advanced Tutorial

Excel 2019 VBA Advanced Tutorial

Get Ad-Free Training by becoming a member today!

Who it's for: Business Analysts, Data Scientists, and everyone in between looking to write their own rulebook on what’s possible in Excel.

What it is: Visual Basic for Applications (VBA) is the programming language for Excel and other Microsoft Office programs. VBA is used to automate repetitive processes and frequent actions. Even more, it can be used to build tools that otherwise don’t exist in Excel.

What you'll learn: In this series, users will be guided through the foundational concepts of VBA in Excel. Users will learn to build macros from the ground up, starting with recording macros that require little to no code, and working towards building their own macros using crucial VBA concepts such as Loop, If Then, and other complex functions.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:

For Private Group Trainings please visit:

Username: manuals
Password: password

Start 0:00
Introduction 0:03
Introduction to Forms and Controls 1:41
UserForm Object-Controls-Properties-Events-Methods 2:36
Reviewing Types of Modules and Inserting UserForm Objects 5:19
Changing Form Properties 8:39
Creating a Label Control and Adjusting its Properties 10:15
Copying a Label Control to Create a New One 13:10
Adding Two Text Box Controls to Forms 14:12
Adding Two Command Button Controls to Forms 16:01
Adding a Combo Box Control and Label 19:21
Adding Two Frame Controls with Three Option Buttons in Each 21:43
Adjusting Option Button Properties 25:16
Aligning and Grouping Form Controls 27:13
Testing and Adjusting Form Tab Order 30:07
Coding the Combo Box to Display Months 34:05
Coding Other Form Controls Using Text Files 38:47
Reviewing Coding in Text Files 41:23
Displaying the Form Programmatically 44:01
Forms and Controls Recap 47:39
Introduction to Pivot Tables in VBA 48:35
Introduction to Creating Pivot Tables 49:18
Creating Pivot Tables by Recording a Macro 52:39
Creating Pivot Tables 57:43
Testing CreatePivot Sub-Procedure 1:01:23
Creating Sub-Procedures to Set Pivot Table Fields 1:02:05
Finalizing Forms 1:09:42
Creating Sub-Procedures to Code Options in the Period Frame on Forms 1:13:17
Reviewing GetLastDate and GetFirstDate Code Blocks from Text Files 1:17:28
Coding Options in the Sales Frame on the Form 1:20:10
Reviewing Text File Procedures - ConsolidateData-GrabCells-FinishReport 1:22:39
Completing Code Modifications for Form Objects 1:26:10
Testing Completed Forms 1:31:12
Adding Icons to the QAT to Run the Form 1:35:55
Pivot Tables Recap 1:38:54
Conclusion 1:41:37

#excel #exceltutorial #exceltips #vba #excelvba

(C) 2022 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

[RedDogByrd]

Trish Conner-Cato, You did an outstanding job. There's really a lot to take in and you need to pay close attention, but if you do this application works great. I was using Excel 2013 and was concerned it might not work since we're in 2022. It did work. I'm a 79 year old retired software developer who has written in many languages over the years and I think you can't beat knowing VBA and Excel. It can always make you a good living and the libraries available seem endless, so it's like a Lego world!

[lberry]

I know this is a year old, but I've watched it twice. When you were testing the form, and changed the Sales to "Model" (around 1:35:00) mine didn't work. It still says SalesPerson as the filter.
When I began troubleshooting, I can't find in the video where you added the other Case statements in the GetSalesByGrouping sub-procedure. My follow-along only has Case "SalesPerson". Did I just miss it....twice? At least I've learned enough to be able to troubleshoot. Is it me, or are those changes missing?

[indysingh]

Hello, excellent course by excellent tutor. Quick question: Is it possible to get the slides file please?

[lberry]

I've really enjoyed this series....until 1:22:50 "Reviewing Text File Procedures- ConsolidateData- GrabCells-FinishReport". This part was covered WAY too quickly. Considering the complexity of the ConsolidateData sub, I feel that there should have been much, much more time spent here.

[cho]

hello i'm a learner from taiwan. I want to ask if record the macro of pivot table and use some code to adjust and connect it to the userform be easier? Sometimes i cannot get the whole picture 'cause the whole code is a little bit complicated and overwhelming. Thank you

[frederickjackson]

Hi Trish, I have followed VBA for the Pivot Table but there is a problem when inputing Dates. I get a Runtime Error 13 it's in the Do Loop in

Sub frmGenerateReports.Period

frmGenerateReports.StartDate = frmGenerateReports.StartDate + 1
GrabCells 2
Do Events


Any Ideas Please Regards Fred