Excel 2019 VBA Beginner Tutorial

preview_player
Показать описание
Excel 2019 VBA Beginner 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
Getting Started 2:06
VBA Overview 3:35
Adding the Developer Tab to the Excel Ribbon 6:48
Record Macro Dialog Box 8:06
Recording Macros 11:43
Testing Macros 15:21
Visual Basic Editor Overview and Changing Font Settings 17:18
Customizing VBE Toolbar 23:54
Editing VBA Code Generated by Recording a Macro 25:53
Using the Properties Window to Rename Objects 34:55
Saving Macro-Enabled Workbooks 38:23
Testing Macro Changes in Another Excel File 41:27
Undoing Macro Steps and Modifying Trust Center Settings 46:09
Getting Started Recap 53:21
Excel Object Model Hierarchy Overview and Collections 54:49
Referencing Objects 59:49
Introduction to Procedures and Functions 1:06:26
Understanding Module and Procedure Types 1:08:05
Naming Rules and Conventions for Procedures 1:10:12
Starting Macro Recordings from the Status Bar 1:12:10
Creating a Macro that Copies Data from Another File into the Current File 1:16:33
Reviewing Methods and Examples 1:18:26
Reviewing Newly Generated Code 1:20:18
Creating a Sub-Procedure from Scratch Using the Insert Menu 1:24:30
Modifying Two Existing Sub-Procedures 1:30:14
Executing Procedures and Creating a Calling Procedure from Scratch 1:35:26
Understanding the Scope of Procedures 1:39:35
Testing Calling Procedures 1:42:50
Creating Event Procedures 1:46:31
Testing Calling Procedures 1:51:13
Creating Function Procedures 1:52:13
Testing Function Procedures in the Immediate Window 1:59:23
Testing Function Procedures in Excel - User Defined Function 2:02:45
Accessing Context Specific Help from VBE 2:05:43
Procedures and Functions Recap 2:09:19
Conclusion 2:10:14

#excel #exceltutorial #exceltips #vba #excelvba

(C) 2022 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
Рекомендации по теме
Комментарии
Автор

Hi Trish, That was an awesome tutorial far beyond scratching the VBA surface . You really master the art of teaching! Thank you for the great work done 👏👏👏!

osoriomatucurane
Автор

This is an outstanding tutorial. Extremely well-presented in a well-ordered sequence. I'm impressed.

ClintR
Автор

Thanks for keeping this so simple, even I understand...so far. I haven't finished yet!

bejai
Автор

Another awesome course by another awesome trainer. Thank you.🙏👍

mowatrcm
Автор

Thank you very much, this was clear professional and educational video, it helped me a lot, I am now moving on to the intermediate one 😁

dandruffo
Автор

You're a great teacher, that was awesome..

BronzeMoon
Автор

Hi Trish, so simple lesson. thank you so much. where can i get the slides used in the video.

DeepakSingh-lrtn
Автор

moi xem 1 cai video la biet lam luon roi thanks ban nhieu lam

waitnkphillips
Автор

Lesson 2, Excel Object Model Hierarchy Collections, blew my mind. A 1000 watt light bulb went off for me. I have tried to understand that for a while, and you put it all together in about 5 minutes of video. Bravo!! Thanks!!

GoToChurchNow
Автор

Thank you for the video, very informative!

1:48:24 For my application on my Mac an error message appears when I select the worksheet object - 'Variable uses an Automation type not supported in Visual Basic' - would you know what this means or how I can solve the problem?

kittycat_
Автор

It's wrong to do like this: Dim i, m, k As Long. Because i and m will be Variant, not Long. In VBA you must specify a type for every variable. So correct way is Dim i As Long, m As Long, k As Long. The same for String, Double, Byte and so on

petrpetrov
Автор

Good contant I also make video on similar subject

VBASqlAccessPowerApps
Автор

Hi, where can i download the slides please? Thanks

njoosoesanto
Автор

The URL for the files in the video description "Cannot be found".

dwarfusinterruptus
Автор

21:21 I don't see "MODULE" under VBA Project and when I tried to insert the module I don't find the code, it's simply blank. Could you please help me finding the appropriate module for the same?

WFi
Автор

Am pre comfy about the coding part, but when it comes to the term of describing it, I kinda confused myself, Like what's a procedure, sub-procedure, or module?

lvrvomj
Автор

Why is that exercise file not opening ??

bhaigrathmandal
Автор

Where can I get the files for this tutorial?

realignmentreport
Автор

Hi, can you do a video how to send jpg image from excel to Whatsapp. Many thanks

raymondchan