Excel VBA Advanced Tutorial

Excel VBA Advanced Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: bit.ly/3kVR38Y
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:
www.learnitanytime.com
Enroll in our live, instructor-led Excel VBA classes:
bit.ly/3tjDDuM
For Private Group Trainings please visit:
www.learnit.com/private-group...
Manuals: bit.ly/30xZb59
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.

[@w7yh]

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 KZbin course. Thank you so much for all the hard work. And thank you everyone who adds new tricks in the comments.

[@LearnitTraining]

Glad it was helpful!

[@lionelren3705]

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

[@LearnitTraining]

Happy to hear that!

[@Lethesys]

i was thinking the same!

[@fahad_hassan_92]

@@Lethesys Me too!

[@caoainguyenang1007]

@@LearnitTraining I feel always debt you a thank.

[@nevertheless7995]

O

[@Boltage23]

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.

[@LearnitTraining]

Thank you for the kind words Boltage23!

[@financedepartment8589]

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 .

[@kensimba7868]

I agree learn it are the best. I follow their videos and they all make me proud. Good job to this institution and I hope the whole world discovers u

[@hazelnuts590]

Hey, is there tutorial that can explain how to create a data entry form on clicking a button generates a word doc?

[@kevintaculao1409]

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

[@stardust7183]

Oh yeah, I got hooked too :D:D

[@nickshutte8369]

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!

[@kensimba7868]

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!

[@LearnitTraining]

Awesome! Thank you!

[@hazelnuts590]

@@LearnitTraining Hey, is there tutorial that can explain how to create a data entry form on clicking a button generates a word doc?

[@souravkar5321]

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 :)

[@proudlycanadian3023]

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!

[@LearnitTraining]

Sie sind herzlich willkommen! Danke für das Aufpassen!

[@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.

[@LearnitTraining]

Thank you so much for the kind words!

[@christopherravlin6051]

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!

[@deepakdivakaran9320]

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

[@LearnitTraining]

You're very welcome!

[@ANIS23100]

This is the best VBA tutorial on KZbin, straight forward very clear explanation .thank you for sharing it with us.

[@LearnitTraining]

Thank you for watching and an extra big thank you for subscribing!

[@ouassimsahil5823]

Truly Amazing! I was very lucky to have found this channel. The tone, the pace, and the exercise files, everything is just top-notch.

[@LearnitTraining]

Welcome aboard!

[@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.

[@IVTkids]

Such a brilliant course. The trainer is amazing!!! Its unbelievable that such content is free.

[@LearnitTraining]

Thank you for watching!

[@jonelbenosa1887]

I really love this tutorial... also the way it was explained... very easy to understand. -a beginer in the philippines!

[@mattlacarra2069]

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.

[@LearnitTraining]

Glad it helped!

[@lucaslomans213]

Thank you for putting this content on KZbin!

[@Zandor434]

Appreciate the tutorial. I like how structured everything is. I knew much of this content already, but it’s easy to fast forward through and there are lots of little tips along the way. Thanks again for the great vid.

[@SaiKumar-vw8rc]

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:)...

[@kpk9311]

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 items..... I wish I had more videos of her on all Excel topics

[@andrewchen9950]

Very clear and concise explanation! Thanks!

[@hamzawaheed47]

Now Flexing for Expert Training! Thank You Learnit ; )

[@sxtywei0001]

Very well explained tutorial alongside with such a beautiful voice. A big thank you to the instructor

[@SMH2007]

This is a very educational VBA video. I learned a lot from it. Thanks for putting it out for us to learn

[@georgetomyacca]

Very Clear and Pervasive !! Thanks for the Tutorial!

[@amjethbasheer7448]

I gained practical knowledge of Excel VBA through self-guided learning, utilizing various KZbin 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.

[@LearnitTraining]

Thank you so much for the kind words! We are glad you learned so much and that our video was able to help you with VBA

[@chandrakalakallimath2203]

This is one of the best tutorial to learn VBA. Concepts are explained so precisely, keep up the good work

[@LearnitTraining]

Thanks, will do!

[@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.

[@LearnitTraining]

You're very welcome!

[@victorwestmann]

The quality of this course is so high that I'm just shocked. THANK YOU SO MUCH FOR SHARING THIS!

[@LearnitTraining]

You are very welcome!

[@_Tezza]

WOW! OUTSTANDING Tutorials. Exactly what I was looking for. You're a legend.

[@LearnitTraining]

Thank you so much for the kind words Terry!

[@iancook2015]

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

[@johnjacobjinglehimerschmid3555]

Using the DEBUG feature of the ide is the best way to slowly go over someone elses code.

[@monakaram2009]

Thank you soo much Learnit ! beautiful training, so well organized, so well thought and just o the point !

[@LearnitTraining]

You're so welcome!

[@NetMistro]

Your explanation is so simple and easy to follow. Thank you

[@LearnitTraining]

You are welcome!

I am surprised that such a great channel like this hasn't got milion of subsribers by now. I am gonna introduce this channel for my friends for sure.

[@LearnitTraining]

Hi Danh! Thank you so much! Sharing helps out a ton!

[@YOMOODY]

I am incredibly grateful for the creator of this course content.

[@LearnitTraining]

Thank you for watching!

[@turnswood]

Great series. Learned more here than other tutorials. Good pace, too. Thanks, Irv in Florida

[@LearnitTraining]

Glad you enjoyed it!

[@razvanungureanu8897]

Excellent video and perfect examples. I have learnt just watching from these videos to almost master vba and create very complex macros. Thank you Chelsea for the great job you do and I'm looking forward watching the Expert tutorial

[@LearnitTraining]

You're very welcome!

[@ashrafshehata6566]

thank you for your supporting and helping

[@LearnitTraining]

Thank you for watching!

[@srinaths3772]

Great tutorial. Easy to understand. Thanks.

[@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.

[@LearnitTraining]

Thanks for sharing!

[@owaisjabri8369]

Really good tutorial and really well laid out so easy to follow.

[@LearnitTraining]

Glad it was helpful!

[@rahulmajumder7968]

Thanks to Learnit Training for this amazing course. Finished the advanced tutorial moving on to the expert. The course materials along with detailed explanations are really very informative and helpful. Thanks again!

[@LearnitTraining]

Thanks for watching Rahul! We hope you learned alot!

[@ivor3801]

Thank you for the great solution, better than ALL the others offered by experts who over-complicated their efforts.

[@LearnitTraining]

You're welcome!

[@jacquelinetung]

Those projects were very fun & challenging, thank you! Heading to the next session :)

[@johantode6910]

Once i finally got this vid running it is excellent again. Because i pause very often and practise all kind of variations it takes me a complete day to finish this tutorial, but it is certainly worth the effort. It may would have finished it by explaining to create a button for that last code, so it is used in the best way, however also finishing the basic course most if not all viewers would probably see that at once.

[@LearnitTraining]

Glad it helped!

[@hashmiakbar8361]

One of the best tutorials for VBA...I actually learned a lot about VBA macro, from these videos..Thank you so much "Learnit Trainings"..

[@LearnitTraining]

You are welcome!

[@sgui8523]

Nevermind!...i found how to unlock it. i right clicked on the file then on General tab went to the bottom and clicked on trusted source. thank you for your lectures! finally learning a lot after a long time of struggling with VBA🥰👍👋

[@rbrtsparkman]

declared in memory, I finally know now.

[@manuelsamuelmanhica7493]

I thank you very much guys! I have been looking for to learn VBA a long time ago time, since I was at college and never managed because of the content was hard to understand. But you guys brought the light to me, and now I am confident of what I have learnt. I would recommend your company to give Excel courses in the company I am working at.

[@LearnitTraining]

Thank you for watching Manuel! We hope your new skills take you far!

[@manuelsamuelmanhica7493]

@@LearnitTraining surely, and I am going to take more courses you're providing through your channel. I visited your page it has a lot of content of my interest, hope one day I pay for one to get the certification.

[@matthewpark8354]

Godlike tutorials, finished the beginner one, onto the next

[@LearnitTraining]

Glad you like them!

[@vivekkumarsingh5704]

Thanks for this incredible tutorial !

[@LearnitTraining]

You are very welcome Vivek!

[@jodybode1834]

PLEASE READ THE ENTIRE POST: This fixed the issue with Sub SortLastCol() in Lessons11 Report Generator and 12. You can type it in the Sub just the way you see it below. I know how frustrating this was for me. Range("A1:D5").Select ActiveWorkbook.Worksheets("Conservative").Sort.SortFields.Clear ActiveWorkbook.Worksheets("Conservative").Sort.SortFields.Add2 Key:=Range( _ "D1:D5"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:= _ xlSortNormal

[@YaNykyta]

I will just repeat previous opinion: The quality of the tutorials is just incredible! You are very talanted!

[@LearnitTraining]

Wow, thank you!

[@davidluo2622]

amazing tutorials. i am really glad they exist

[@LearnitTraining]

Thank you for the kind words David!

[@jennieyang1415]

Excellent tutorial. Extremely clear. Thanks so much.

[@LearnitTraining]

You're very welcome!

[@baphnie]

This content is phenomenal. Also, wanted to point out that getting to the last entry in a region of data is easier than going to some arbitrarily deep row in your sheet and moving up; just chain .End statements. Selection.End(xlDown).End(xlDown) moves you first down to the top of a region of data, then to its last row.

[@LearnitTraining]

Thank you for watching baphnie and thank you for the tip!

[@razvanhasegan1974]

Those VBA for Excel tutorials help me a lot! Thank you! :D

[@LearnitTraining]

Glad you like them!

[@sruthildinesh9125]

Excellent video...got a lot of insight into VBA

[@winardix]

Your voice is crunchy and a very nice aiueo. It helps in learning

[@joyfuljewelful]

Watched beginners last night and advanced tonight! Really appreciate these tutorials! Now Just need to practice and practice more.

[@LearnitTraining]

You got this JP!

[@joyfuljewelful]

What is the best practice on dropping code. I know you said to put in the module. But what if I have a button on a sheet where the button is only valid in that sheet and not the workbook itself? Should I drop code in the sheet instead? Thanks!

[@BilalHussain-gc2sf]

Excellent material for beginners to get a detailed and easy understanding of VBA.

[@BilalHussain-gc2sf]

brogrammer

[@LearnitTraining]

Thank you for watching!

[@proudlycanadian3023]

Thanks very much for the lesson! It was absolute perfection! Despite being extremely difficult, I successfully persisted and have mastered perfectly!!!

[@LearnitTraining]

Great job!

[@amitpoonia1123]

Excellent Madam. God bless you forever. Be happy healthy. LOVE FROM INDIA. Thank you

[@LearnitTraining]

Thank you for your support Amit!

[@shugaRaye]

who this chic is!! I don't have to hear smacking or clearing here throat when she talks; i don't have to hear her beating the crap outta her keyboard; the content is on point and all of the sheets are actually up2date. Chica, you are freaking awesome!!

[@LearnitTraining]

Thanks?

[@faruqhsj]

Very useful and interesting. Great to listen and follow the motherly instruction with balanced care about the productive learning ! Thank you so much dear instructor of the Learnit Training !

[@LearnitTraining]

Glad it was helpful!

[@namaste_canadaa]

Amazing content! You made it look so easy to understand. Thank you!

[@LearnitTraining]

You're very welcome!

[@kebincui]

Great tutorial! Thank you so much Chelsea!

[@LearnitTraining]

You are so welcome!

[@johnjudge570]

Chelsea Dohemann, you are an awesome teacher!!! Thanks for doing this video!

[@LearnitTraining]

Glad it was helpful!

[@kishormanandhar2804]

A truly helpful content....I got to learn so much within 4 to 5 hours. Thank you @Learnit Training for uploading such quality content.

[@LearnitTraining]

Glad it was helpful!

[@Matt-zp9jg]

This video is beyond helpful! Thanks so much for this awesome lesson :)!

[@LearnitTraining]

You are very welcome! Thank you for watching!

[@Bedguys]

I love this chanel, thank you so much!!! Keep up the amazing work!

[@LearnitTraining]

Thank you! Will do!

[@binodluhar7190]

Thank you so much for the tutorial. You explain very well with clear voice

[@LearnitTraining]

You're very welcome!

[@Mr3213215]

You have a nice voice, mam. Thanks a lot.

[@qww760]

I really like this instructor. She's very engaging.

[@LearnitTraining]

Thanks!

[@qww760]

@@LearnitTraining I recommended this video series to several coworker too.

[@bear76917]

This video is awesome. I finally can understand and step by step write my VBA.

[@LearnitTraining]

Thank you for the kind words L Teddy!

[@adouble6533]

I didn't have known that excel has so many functions like above video. Thank you for those contents!

[@LearnitTraining]

Happy to help!

[@rodlusk1649]

Thank you for the effort you have put into these videos. I have signed up for several, as I'm new to VBA marcro's, and yours are by far the most organized and clearly explained. I'm in the "Exit for" worksheet and the macro is to exit when the value in column B is "stop". I put "Stop" into cell B4 and the macro did not exit as it should. Is this because you have already defined it to run from cell 1 to 50, so it actually doesn't exit at a "Stop"?

[@AJR0004]

Late but, for anyone else who has this issue, I think it's case sensitive. So if it's looking for "stop" when the cell value is "Stop" it'll keep going because it's looking for stop with lowercase "s"

[@thecentralscrutinizerr]

I think I'm in love just from the sound of her voice. It was love at first sound. When it came to the "Exit For" example, I kept entering Range("A1" & x) and couldn't figure out why it was starting on cell A:11 when I ran the code. I'm just so use to entering complete range values. I was like, "Is my addins causing this? Is my Excel hosed up? Are my DLL files corrupted? Is my system memory going bad?" LOL!

[@ladylolo2449]

Incredibly helpful!!!!

[@LearnitTraining]

Glad it was helpful!

[@Bharatmsharma]

This is what i wanted very crystal clear to the point explanation. Awesome I am going to refer this as my VBA bible.

[@LearnitTraining]

Thank you for watching Bharat!

[@weihern9741]

Teaching is super clear. Accent is also not making me sleepy. This is perfect for those who are familiar with excel but want to start learning VBA. Once you got the hang of the basics, you can simply use record macro, edit it to see how the code looks like and utilize into your VBA.

[@weihern9741]

Another thing i found useful is in order to insert variable into range, you use Range(Cells(1,1),Cells(x,2)). This will give you Range("A1:Bx").

[@LearnitTraining]

Thank you for the kind words!

[@wintermorillo6567]

Great content. There are not word to describe how amazing it is.

[@LearnitTraining]

Thank you for the kind words!

[@adrianchojnacki8680]

You exactly cound't have done it better! Perfect tuturial

[@LearnitTraining]

Thanks so much!

[@meryemboutbagha8829]

Merci d'avoir posté de telles vidéos. un travail très professionnel. Mille Merci

[@LearnitTraining]

Merci d’avoir regardé!

[@hazemali382]

Great Tutorials

[@stevealdrich2472]

Dim actually means "dimension" but "declared in memory" is quite useful and as good as the real meaning.

[@LearnitTraining]

Thanks!

[@animacionparaeducar]

uno de los mejores cursos que he tomado...muchas gracias por este aporte

[@LearnitTraining]

¡Gracias por mirar! Nos alegra que lo haya disfrutado!

[@Alex_de_Souza1981]

Wonderful. Pure, effective and efficient learning

[@LearnitTraining]

Many thanks!

[@Hakugarawe]

Thank you very much for this treasure.

[@LearnitTraining]

Thank you too!

[@BOWENSblog]

Interesting presentation. I'm not sure I'll need these ideas but that's a good presentation

[@johnnycheung88]

Great tutorial!

[@LearnitTraining]

Thank you! Cheers!

[@SteveBlake777]

At around 1:44:30, it was mentioned that "Dim Message, TitleBarTxt, DefaultTxt, SortVal as String" will declare all those variables as "String". Actually, only the last variable will be a "String" The other variables will be declared a "Variant". This can be validated by right-clicking on (i.e., Message) and add to watch. Do the same to "SortVal". If you put a break just after that declaration, you will see the "Type" in the watches window.

[@amjethbasheer7448]

Right! May be the only option will be to declare as: Dim Message As String, TitleBarTxt As String, DefaultTxt As String, SortVal As String

[@andrynantenainaranaivojaon4569]

Thank you very much for this tutorial!

[@LearnitTraining]

You are very welcome!

[@LambertoSalucco]

Great content. Thank you.

[@LearnitTraining]

Glad you enjoyed it!

[@kodjolarbi9694]

This tutorial is very helpful, thanks for the effort you have put to make these video

[@LearnitTraining]

You're very welcome!

[@deiaabdullah2008]

Great and very well organized ...Thanks for your efforts

[@LearnitTraining]

Most welcome 😊

[@Arbitraritorian]

Learning so much. Thank you! 💕😍💕

[@LearnitTraining]

Thank so much for watching!

[@portiasickuku2492]

Thank you for this awesome content, life saver!!!!

[@LearnitTraining]

You are so welcome!