Excel VBA Beginner Tutorial
For ad free training and certificates please join Learnit Anytime:
https://www.learnitanytime.com
Enroll in our live, instructor-led Excel VBA class:
https://bit.ly/3I4q5Yh
For Private Group Trainings please visit:
https://www.learnit.com/private-group-classes-workshops
Join our online community! – https://www.offsitebylearnit.com
Exercise Files: https://bit.ly/3kVR38Y
Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:03
What is VBA? 1:44
Object Oriented Programming Languages 5:59
Turning on the Developer Tab 10:17
The Macro Recorder 13:40
Using Relative References 20:39
Recording Simple Macros 27:51
Multi-Step Macro Recording 39:25
Sort and Filter Macro Recording 45:26
Protecting and Formatting Sheets with the Macro Recorder 51:35
VBA Interface Setup 55:09
Recorder Code vs. Manual Code 1:01:11
Introduction to Editing Macros 1:12:28
Debugging Macros 1:16:53
Grammar in VBA 1:28:00
Macro Scripting Basics 1:33:04
Range 1:40:41
Selection & Color 1:47:14
Value and Clear 1:52:16
ActiveSheet, Sheets, and Name 1:54:01
CurrentRegion 1:56:40
Practice 1:58:08
#ExcelVBA
(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
source