Excel VBA Advanced Tutorial

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

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

[@sunnysumanth1280]

I am using brave browser to skip ads bruh 😂😂😂😂

[@YaNykyta]

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

[@LearnitTraining]

Wow, thank you!

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

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

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

[@mrCetus]

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!

[@LearnitTraining]

Glad it was helpful!

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

[@IVTkids]

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

[@LearnitTraining]

Thank you for watching!

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

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

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

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

[@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🥰👍👋

[@YOMOODY]

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

[@LearnitTraining]

Thank you for watching!

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

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

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

[@BilalHussain-gc2sf]

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

[@BilalHussain-gc2sf]

brogrammer

[@LearnitTraining]

Thank you for watching!

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

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

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

[@A-broken-clay-jar]

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

[@LearnitTraining]

Thanks!

[@A-broken-clay-jar]

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

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

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

[@ivor3801]

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

[@LearnitTraining]

You're welcome!

[@ashrafshehata6566]

thank you for your supporting and helping

[@LearnitTraining]

Thank you for watching!

[@senftube2460]

Thanks for your great tutorials! Few critic points I have: -using the selection object often leads to mistakes and longer runtimes, and can almost always be avoided. Imo, it would be better to mention that in the beginning of the video. -using "x" as a variable is not very telling, "spelling" names are better, like "intTemp" for temporary integers, or "intCurrentRowTemp" for filling rows in a for-loop -it is very important to do good (!) commenting which could be added inbetween cuts, just to show how its done Other than that, this is easily the best tutorial I have seen so far. Easily followable with a red line throughout the whole tutorial.

[@LearnitTraining]

Thank you for the great tips!

[@micahblasko3384]

When she declared inRow instead of intRow, the program didn't error because it just made intRow a variant. So its not necessary to declare those variable before hand, but just like she said it saves space because variants are large data types.

[@HuyenPham-fy7iv]

Thank for the explanation.

[@LCastejon]

Thank you for that!! I noticed the typo and was wondering how it still worked. Was hoping someone in the comments addressed it 🙏🏼

[@caoainguyenang1007]

As a Vietnamese, I am learning VBA and Ennglish Listening same time. Great on Covid stay home.

[@LearnitTraining]

Best of luck!

[@rbrtsparkman]

declared in memory, I finally know now.

[@adouble6533]

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

[@LearnitTraining]

Happy to help!

[@A-broken-clay-jar]

I just finished the video. On to the Expert video next.

[@LearnitTraining]

Hope you enjoyed it!

[@A-broken-clay-jar]

@@LearnitTraining I did. I even watched the next one. I had a whole OneNote document just to grab the hard to remember technique you covered.

[@govand3622]

Hi ms And Leanit team im not a commentor actually but i couldnt help it these course that you guy give people for free!! mygosh its incredible and honestly much better than the pay course i just wanna give a sincere thank from deep of my heart(Love from Iraq - Kurdistan)

[@LearnitTraining]

You are very welcome!

[@stevealdrich2472]

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

[@LearnitTraining]

Thanks!

[@johnjudge570]

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

[@LearnitTraining]

Glad it was helpful!

[@RahulJha-wt7jm]

What a nice session it is! Only request I have is to provide this session in Hindi as well. Some of my friend would understand better in Hindi.

[@LearnitTraining]

Possibly in the future

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

[@turnswood]

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

[@LearnitTraining]

Glad you enjoyed it!

[@faiyazahmedansari4199]

Professionally explained and easy to understand all aspects of the courses, we can imagine how much efforts has been put to create such tutorials. Hats off to Learnit Training team and offcourse to the Trainer who has a powerful coaching skills, I really thank you all for your efforts with load of love and respect, please don't stop the good cause........

[@LearnitTraining]

You're very welcome!

[@vivekkumarsingh5704]

Thanks for this incredible tutorial !

[@LearnitTraining]

You are very welcome Vivek!

[@ManishGuptaPrasad]

Small Correction. When you are explaining Double for next loop. you declared a variable as "Dim InRow as Integer" but in the loop you used intRow and it still works.

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

[@binodluhar7190]

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

[@LearnitTraining]

You're very welcome!

[@astridlundmark5055]

Super-nice! Thanks! The only thing that could be better is the image quality. On my screen things get blurry, which makes me tired. But the suggestions for other videos on the right-hand side are razor-sharp, isn't it ironic!

[@LearnitTraining]

Thanks for the tip!

[@SMH2007]

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

[@andrewchen9950]

Very clear and concise explanation! Thanks!

[@alanadossayeva2385]

This tutorial is amazing. and thank you for inviting Kristen Bell as a voiceover!

[@LearnitTraining]

You're so welcome!

[@owaisjabri8369]

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

[@LearnitTraining]

Glad it was helpful!

[@rogobil6897]

have just finished learning it was pretty fun to do

[@LearnitTraining]

Thanks for watching!

[@rogobil6897]

@@LearnitTraining is this an automated response or an actual person

[@kennimmannit5933]

Thank you so much, instructor know how to teach

[@LearnitTraining]

You are welcome!

[@adrianchojnacki8680]

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

[@LearnitTraining]

Thanks so much!

[@jennieyang1415]

Excellent tutorial. Extremely clear. Thanks so much.

[@LearnitTraining]

You're very welcome!

[@monakaram2009]

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

[@LearnitTraining]

You're so welcome!

[@fahad_hassan_92]

How is this content free!? I cannot express how much I love this content!

[@LearnitTraining]

Thank you for watching Fahad! Hitting the like, subscribe, and sharing keeps the channel going!

[@fahad_hassan_92]

@@LearnitTraining Sure!

[@jossdelrio7619]

Maravillosa un tutorial sin costo wooooo🎉 es increíble quiero más.

[@LearnitTraining]

Gracias por las amables palabras

[@jacquelinetung]

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

[@bogdan-remuspintilie5569]

Thanks for all and great work. I really appreciate the slow method for explaining things and the simplicity of ideas. Special Thanks $ will be received if I get the internship :)). Thanks again. P.S. 9.Duplicating Data video was skipped.

[@LearnitTraining]

Glad it was helpful!

[@Aeromir]

Doesn't DIM mean "Dimension?" That's what it was in other programming languages I learned many years ago.

[@kebincui]

Great tutorial! Thank you so much Chelsea!

[@LearnitTraining]

You are so welcome!

[@kevintaculao1409]

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

[@stardust7183]

Oh yeah, I got hooked too :D:D

[@jonelbenosa1887]

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

[@johnnycheung88]

Great tutorial!

[@LearnitTraining]

Thank you! Cheers!

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

[@jdionne666]

These tutorials are wonderful thank you very much, But being a old school VB developer Dim means Dimension not "Declared in memory", VBA is just a Waterdown VB all statements mean the same, with added Application objects.

[@LearnitTraining]

Thank you for the tip!

[@tomamore3]

Just so you know Dim is not an acronym. It is short for dimension. You are dimensioning the amount of memory need by the variable type.

[@LearnitTraining]

Thank you for the tip!

[@caoainguyenang1007]

I am supprised at 1:32:40. You used 2 (two) "If" statement, but only 1 (one) End If, and it still work. I have tried, but have to use 2 (two) End If.

[@mikitakhanchyn2018]

Great! Two lessons and I did my work easier!

[@LearnitTraining]

Glad it helped!

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

[@LambertoSalucco]

Great content. Thank you.

[@LearnitTraining]

Glad you enjoyed it!

[@jaikm865]

Simply amazing contents

[@LearnitTraining]

Thank you so much for the kind words!

[@Arbitraritorian]

Learning so much. Thank you! 💕😍💕

[@LearnitTraining]

Thank so much for watching!

[@andrynantenainaranaivojaon4569]

Thank you very much for this tutorial!

[@LearnitTraining]

You are very welcome!

[@georgetomyacca]

Very Clear and Pervasive !! Thanks for the Tutorial!

[@googleguides9710]

Outstanding stuff 😘😘

[@LearnitTraining]

You are very welcome!

[@danp6101]

Declaring more than one Variable on a Single In Excel. Example Dim A, B, C, D as String. Only Makes The last Variable a String the other Variables Become a Variant You Can open up the Locals window and check to see what type the variables become. You Have to use As String after Each Variable To Be a string Variable if that's what you want Dim A as String , B as String , C as String, D as String. This is the Correct way to do it.

[@LearnitTraining]

Thanks for the tip!

[@Mr3213215]

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

[@seppwebber785]

Great content!

[@LearnitTraining]

Thanks for watching!

[@WladimirWostok]

At 25:40 it's easier to use " If Selection.Value = "Stop" Then " as the cell is already selected previously. TML 🤗 At 46:32 I found out that the two lines can be replaced by "ActiveCell.Offset(1, 0).PasteSpecial", as the Cell is already selected when an offset of a selected cell is performed.

[@LearnitTraining]

Thanks for the tip!

[@srinaths3772]

Great tutorial. Easy to understand. Thanks.

[@sakksha]

Hey! Absolutely great tutorials. Just a request to add 'Start 0:00' above the timestamps in your description as that will help the timestamped videoparts into the video progress bar (the scroll bar thing in the the video player) too:)

[@LearnitTraining]

Done!

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

[@Bedguys]

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

[@LearnitTraining]

Thank you! Will do!

[@Matt-zp9jg]

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

[@LearnitTraining]

You are very welcome! Thank you for watching!

[@SantiagoMolero]

Thank you very much!!!

[@LearnitTraining]

You're welcome!

[@rajashekarabboju]

Thank you very much.. awesome flow.

[@LearnitTraining]

You're very welcome!

[@Rohitkumar-wk2vo]

Very nice tutorial as expected from learnit

[@LearnitTraining]

Glad to hear that! Thank you for the continued support Rohit!

[@tezausbra8]

Such a great tutorial!

[@LearnitTraining]

Thanks so much!

[@hakanaltintas1]

Super useful!

[@LearnitTraining]

Thank you for watching!

[@faizulanuar2474]

Came here from the Beginner video. Is there an 'intermediate' video, or is this the next lesson? Thank you for the high quality video :)

[@MNEMETH318]

I thought the same thing but then noticed that it's a continuation from the Beginner Course as it picks up using Worksheet #5. (Beginner used #1 - #4)

[@hilalgercek2919]

you are amazing... thank you

[@LearnitTraining]

You are welcome!

[@neronjp9909]

Amazing video

[@LearnitTraining]

Thanks for the visit

[@inactiverahul]

52:50 55:30 Finds Data in Column A1, CopyPaste in A4, insert headers,

[@hannahabi3204]

In Sub procedure NumberaVariable(), you should daclare the aPrice variable as Double since the Price is Decimal Number, not Integer. Otherwise, It will round up to an Integer.

[@LearnitTraining]

Thanks for the tip!

[@jerry171460]

Great Stuff!

[@LearnitTraining]

Thanks!

[@BOWENSblog]

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