Excel VBA Advanced Tutorial

Excel 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.

For ad free training and certificates please join Learnit Anytime:

Enroll in our live, instructor-led Excel VBA classes:

For Private Group Trainings please visit:

Username: manuals
Password: password

Start 0:00
Variables 0:03
Variable Rules 7:59
For Next Loop Basics 11:18
For Next Loop Doubled 15:44
For Next Loop Triple 19:47
For Each Loop 22:11
Exit For Statement 23:50
Do While Loop 27:07
Do While Not Empty Loop 30:32
Do Until Loop 32:53
Do Loop UNTIL 35:11
Count and Offset 36:49
End, Address, Call Statement 48:23
Practice 55:35
Using the FIND Tool in a Macro 1:03:47
Message Boxes 1:14:50
Input Boxes 1:22:58
Code Continuation Character and vbCrLf Constant 1:27:16
If Then, ElseIF, and Else 1:33:44
Select Case 1:40:13
Multiple Variables 1:42:58
Practice 1:46:09

#ExcelVBA

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

[wyh]

I come here from the beginner class with zero knowledge and I'm nearly at the end of this video. The effort put in was way more than what I can ever expect from a free Youtube course. Thank you so much for all the hard work. And thank you everyone who adds new tricks in the comments.

[lionelren]

I can't believe this content is free, the quality of the tutorials is just incredible !

[Boltage]

That's how a class is supposed to be. The didactics is perfect and the instructor's voice is very pleasant. Can't get any better than that.

[kevintaculao]

Finished Beginner training yesterday now Advanced! Let's do this! :)

[financedepartment]

Learnit is the excellent education system i am old lady aged 67 watching and learning excel as well as VBA videos . Tons of Thanks to learn it team .

[nickshutte]

I have watched many VBA tutorials, this is one of the best I have seen. Your voice is crystal clear and you explain the content very well. Thank you!

[souravkar]

I generally don't comment but this is really good and simple for someone who has not worked with VBA before.
Thank you so much for posting this :)

[RedDogByrd]

Chelsea, I think you do a really great job. You are the best. Keep up the good work. I'm a 79 year old coder who's been at it for 50+ years, so I've sit through lectures.

[kishoreyc]

Just done with Advanced. At this stage I can safely say that i am not fully thorough with using For Loop, Do Loops, Select, Endf, Endifelse etc., but i am now exposed to all of these in the best way possible.

[kensimba]

Woooow 👏👏👏 I have made sure I watch every ad that pops up in this video just to make 'learn it' earn as much as possible. Whichever long ad I couldn't watch I did let it play till it's over. Fellow viewers am encouraging u not to skip any ads just to boost revenus for this lovely institution. They deserve it!

[deepakdivakaran]

I can't thank you enough. It's such a good tutorial for everyone who wants to explore excel macros. Once again Hats off!

[kpk]

I ended up on this video ....while searching object and variable difference....and am glad that it gave me more than that!!!!

The voice of this tutur will always remain in my memory, . How she beautifully explained each

I wish I had more videos of her on all Excel topics

[mattlacarra]

So glad I found this tutorial. Just got done with the first lesson. Within the first 2 minutes, "Dim" was explained. From other videos I watched, they said it was short for "Dimension". "Declare in memory" makes so much more sense.

[SaiKumar-vwrc]

There is no such thing which is as great as sharing knowledge..and the knowledge is directly proportional to earning money.. Hats off for your time and helping other:)...

[stadrag]

I am absolute beginner, have no experience with VBA and yet I have watched just first 2 tutorial videos from you and i managed to make my first program and wrote about 200 lines of codes, that uses different formulas, depending on the value of other cells (mostly using "if and elseif" tho).
Anyways, your content is really amazing and very helpfull. Any your way of teaching is awsome.

[amjethbasheer]

I gained practical knowledge of Excel VBA through self-guided learning, utilizing various YouTube channels and discussions on Stack Overflow. I do wish I had come across these tutorials when I first started learning VBA, but I'm pleased that I eventually discovered them. Now I am capable of producing more organized and easily understandable code.

The instructor's teaching approach is truly impressive. The clear narration of each step, along with pauses that allow the viewers to practice using provided sheets, creates an ideal learning experience for anyone interested in learning VBA. I highly recommend this resource as the primary option for those wanting to learn VBA. Many thanks for providing free access to this valuable resource for everyone.

[christopherravlin]

LOVED this tutorial. I have questions about connecting variables to button selections in a slice or with dropdown lists, but I am working on it!

[ComeauSoftwareSolutions]

Great series of videos. Thank you!

1:22:44 - Another option is to declare the variable as a VbMsgBoxResult. This is the type that corresponds to the numeric constants returned by the message box. Then, when you test the result in the IF statement, Intellisense will pop up the list of available constants.

[proudlycanadian]

MEINE FÄHIGKEITEN IN VISUAL BASIC SIND EINFACH ABSOLUT PERFEKT, TADELLOS UND MAKELLOS IN HÖCHSTEM MASSE! DIESES VIDEO IST WIRKLICH BRILLANT, FANTASTISCH UND GROSSARTIG! ICH DANKE IHNEN SEHR, SEHR VIEL!

[iancook]

Thank you for putting this together, we have a lot of instances where VBA is used, I've always had a rough idea what the code was trying to do but not enough confidence to start changing it, I feel more equipped now to maybe start trying that