Excel 2021 VBA Beginner Tutorial
Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Exercise Files: https://learnitanytime.com/p/exercise-files-excel-2021-vba-beginner-tutorial
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 the basics, giving you an overview of what you can do with 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 by learning how to save a macro-enabled workbook and modify trust center settings pertaining to macro security. We will then move on to understanding the Excel Object Model, collections, and how to reference objects in VBA code. Once those basics are covered, you will be ready to move on to learning about the 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 a form and programming its controls. During this lesson, you will learn about form properties, events, and methods, and learn how to add controls to the form and modify control properties. 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. The series ends with you learning how to deal with code errors (debugging) and how to write error-handling code. By the end of this training series, you will be equipped with the basics to start writing your own VBA code, modify macros you’ve recorded, and have an understanding of how VBA lends itself to creating efficiency in your daily tasks.
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com
For Private Group Trainings please visit:
https://www.learnit.com/private-group-classes-workshops
Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:03
VBA Basics 1:59
Getting Started 3:56
Example of Object-Oriented Programming Using Excel 5:17
Why VBA? 6:19
VBA vs Macros 7:01
Adding the Developer Tab to the Ribbon 8:33
Filling in the Record Macro Dialog 10:14
Recording Macros 13:21
Testing Macros 16:14
Exploring VBE 17:43
Viewing VBE Options and Reviewing Macro Code 21:06
Editing Macro Code and Using Project Explorer and Properties 28:00
Adding Useful Commands to the Toolbar 32:49
Saving Macro-Enabled Workbooks 35:52
Testing Edited Macros 38:56
Reviewing and Changing Security Settings 41:49
VBA Basics Recap 46:20
Excel Object Model Hierarchy and Collections 47:52
Referencing Objects and Simplifying Object References 52:34
Introduction to Modules and Procedures 58:46
Understanding Modules 59:50
Understanding Procedures 1:01:53
Recording More Macros 1:06:42
Creating Sub-Procedures from the Menu in VBE 1:11:04
Reviewing New Code and Editing Existing Code 1:16:49
Creating Calling Procedures 1:21:15
Testing Calling Procedures 1:24:56
Creating Event Procedures 1:26:10
Creating Function Procedures 1:31:10
Reviewing and Testing Function Procedures 1:37:30
Getting Context Sensitive Help in VBE 1:42:35
Modules and Procedures Recap 1:45:58
Conclusion 1:47:27
#excelvba #exceltutorial #vba #exceltips #excel #visualbasic
(C) 2023 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
