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 RU-vid course. Thank you so much for all the hard work. And thank you everyone who adds new tricks in the comments.
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.
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!
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.
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!
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.
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
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:)...
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🥰👍👋
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.
I gained practical knowledge of Excel VBA through self-guided learning, utilizing various RU-vid 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.
Another excellent video. I find everything much clearer by working through lots of examples and explaining bits of necessary theory as we go instead of too much theory all in one go. Looks like Beta isn’t a stable as we’d like it to be. Already in the first exercise, I hit a problem. The code… Dim aPrice As Integer aPrice = Range("H3").Value Range("C5").Value = aPrice …returned $2 in C5 instead of the $1.50 stored in cell H3 However, when I typed it into the Immediate Window, the same code returned the correct amount $1.50. The code… Dim aPrice As Integer aPrice = Range("H3").Value Dim IncreasingNumber As Integer IncreasingNumber = aPrice + 1 Range("D5").Value = IncreasingNumber …returned $3 instead of $2.50... because it’s fetching the incorrect value from H3. Fortunately, Beta behaved itself for the rest of the examples in your wonderful video.
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.
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.
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.
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.
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 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.
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.
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
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.
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.
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!
Excel VBA Advanced Tutorial is a well planned tutorial. It gives a better learning experience. The voice in the video is pretty clear but the display is blurry at many segments. However, no doubt, a lot of efforts are taken to create the tutorials. Thank you for making it available on youtube.
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!
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.
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
This is very good informative content which found me and after watching lots of misleading videos. verry well explained with teaching thought instead of creating videos.
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!
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........
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.
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)
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
Thanks very much for the lesson! It was absolute perfection! Despite being extremely difficult, I successfully persisted and have mastered perfectly!!!
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.
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.
Great series...it has been a while since I have done any BASIC and this is helping me tie it to the MS object model. By the way "Dim" is not "declare in memory", it stands for "dimension." But, I am now showing my age :D
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:)
This beats Udemy by a mile. Even the supposedly "best selling" instructor of VBA courses there is nowhere near as clear as this. Whoever this lady is here, tell her I said thank you, and I'd buy her a cup of coffee.
@@LearnitTraining Thank you, I just subscribed to her. I really hope she comes back and continues making videos. She's one of the clearest instructors I've seen - in college, online, anywhere.
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!
The "Exit For" statement certainly is only for learning purpose. On the job you would prefer to use the "Do While" statement. More performance, more beautiful, more useful.
I almost always use For Next for looping. It seems to have less chance to overflow because of automatic increment. It's easier to read because reader will know exactly what happen, why it happens and when it happens. It's easier to go through objects. Can you clarify your points in more details?
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!!
hi, you can try below code for example considered under example No. 10 Sub mytry1() Dim x As Integer For x = 1 To Worksheets.Count - 1 Worksheets(x).Select Range("A1").Select Selection.End(xlDown).Select Selection.CurrentRegion.Copy Worksheets("Aggressive").Select Range("A100").Select Selection.End(xlUp).Select If ActiveCell "" Then ActiveCell.Offset(1, 0).Select End If ActiveCell.PasteSpecial Next x Worksheets("Aggressive").Select Rows("1:3").Insert Range("A1").Select ActiveCell.FormulaR1C1 = "Our Global Company" Selection.Font.Bold = True Selection.Font.Size = 16 Range("A3").Select ActiveCell.FormulaR1C1 = "Symbol" Range("B3").Select ActiveCell.FormulaR1C1 = "Open" Range("C3").Select ActiveCell.FormulaR1C1 = "Close" Range("D3").Select ActiveCell.FormulaR1C1 = "Net Change" Range("A3:D3").Select Selection.Font.Bold = True Selection.Font.Size = 12 Selection.Font.Color = vbBlack Selection.Interior.ThemeColor = xlThemeColorAccent1 Columns("A:D").AutoFit End Sub
Dim Inrow as integer is not necessary as can be seen by your typo not throwing an error. YOu create Dim inRow , then recreated a new variable which is only in scope in the first For Loop. intRow is a new variable available in the second For Loop.
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.