Excel 2021 VBA Advanced Tutorial

Excel 2021 VBA Advanced Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: learnitanytime.com/p/exercise...
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 4-part series, we start with an overview of VBA and its advantages over recording macros in the Excel interface. We'll record a macro, which produces VBA code in the background, and learn the Visual Basic editor environment before editing the code generated by our macro. Throughout this section, you will learn some key terminology that will help you along the way. We will end the first lesson with saving a macro-enabled workbook and modifying trust center settings pertaining to macro security. You'll understand the Excel Object Model, collections, and how to reference objects in VBA code. Next, we'll go over different types of procedures, creating procedures, learning the scope of procedures, and working with methods. You will also learn how to get VBA context-specific help from within the editor. A key component of VBA is language elements. We will learn about this important topic by going over variables, their scope, and how to declare them. You will also gain an understanding of VBA data types, intrinsic functions, and the With-End With structure and how it provides efficiency in your code. You will also learn to create message boxes and input boxes in this lesson, as well as gain an understanding of object variables. The next lesson will teach you how to control program flow through supported control-of-flow structures. This lesson begins with an overview of structures and Boolean expressions. You will then learn how to utilize conditional branching, with the lesson ending with looping constructs. We move into creating forms, including properties, programming, controls, events, and methods. You will ultimately launch a form with code. The next lesson will take you through the steps necessary to create a Pivot Table programmatically in VBA. We end debugging and how to write error-handling code. By the end of this training series, you will be equipped to write your own VBA code, modify macros you’ve recorded, and create efficiency in your daily tasks with VBA.
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
www.learnitanytime.com
For Private Group Trainings please visit:
www.learnit.com/private-group...
Manuals: bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:03
Introduction to Forms and Controls 1:20
Form Properties, Methods, and Events 2:45
Inserting and Modifying UserForm Objects 5:20
Using Label Control on Forms 8:04
Using Textbox Control on Forms 11:23
Using Command Button Control on Forms 12:49
Using Combo Box Control on Forms 15:39
Using Frame Control on Forms 17:26
Using Option Button Control on Forms 18:54
Changing Option Button Properties 20:59
Formatting Form Controls 22:59
Testing and Modifying Tab Order on Forms 27:00
Using Code to Populate Combo Boxes and Setting Defaults 30:18
Modifying Combo Box Code and Inserting Control Code Files 35:17
Reviewing Inserted Code 37:58
Testing Modified and Inserted Code 40:50
Writing Code to Display Forms 42:48
Forms and Controls Recap 44:18
Introduction to Pivot Tables in VBA 45:42
PivotCache, PivotTable, and PivotFields Objects 46:59
Recording Macros to Create PivotCache 51:09
Recording Macros to Set Pivot Table Fields 52:40
Reviewing Macro Codes 53:55
Creating Pivot Tables Programmatically 55:19
Creating Code to Set Pivot Table Fields 1:02:02
Finalizing Forms 1:08:38
Reviewing Inserted Code 1:12:45
Finalizing Code 1:15:05
Creating and Modifying Function Procedures 1:19:06
Testing Forms 1:21:56
Adding QAT Icon to Launch Form 1:26:39
Testing Final Forms 1:29:13
Pivot Tables in VBA Recap 1:32:38
Conclusion 1:35:22
#excelvba #exceltutorial #vba #exceltips #excel #visualbasic
(C) 2023 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

[@LearnitTraining]

Exercise Files: learnitanytime.com/p/exercise-files-excel-2021-vba-advanced-tutorial

[@frederickjackson7877]

Hi Trish, within the SUB GetDates under the Case "Other" both the StartDate and EndDate are declared Public As type Dates, However they are then assigned a String that creates problems
To overcome the problem best to amend to StartDate = CDate(txtStartDate) and EndDate = CDate(txtEndDate) in the SUB GetDates()
Trish your presentation and detailed explanation of Excel VBA is first class Thank you so much.
Fred

[@LearnitTraining]

Thank you for the tip Fred!

[@analuizanb]

That's because you already know VBA. She dumped a ton of code and didn't really explain anything.

[@alejandrocruz7869]

Title does say Advanced@@analuizanb

[@luqmanshah7942]

Hello. Are you guys going to release a course on Office Scripts, considering it was introduced to Excel Desktop not too long ago? I use VBA frequently at work, but I would love to learn Scripts to use in conjunction with Power Automate.
Thank you for all the learning resources.

[@LearnitTraining]

Yes! We are working on creating the course currently. Hopefully we can get it up soon!

[@salah_sinjer]

hello, I could not find the slides, I only found the xlxs files

[@byteseq]

"Public StartDate, EndDate as String" gives you one Variant and one String! Not two variables of type String! Common mistake

[@LearnitTraining]

Noted!

[@karramgraphics]

please share us adobe after affect

[@LearnitTraining]

Coming soon!

[@apwonders9311]

Is their an intermediate tutorial

[@LearnitTraining]

Here you go: czcams.com/video/9SxjWg9UBiY/video.html

[@brianyang1572]

Good morning ☀️

[@LearnitTraining]

Good morning Brian!