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 UA-cam course. Thank you so much for all the hard work. And thank you everyone who adds new tricks in the comments.
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!
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!
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.
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:)...
I gained practical knowledge of Excel VBA through self-guided learning, utilizing various UA-cam 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.
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 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.
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🥰👍👋
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.
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 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
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
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.
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.
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!
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.
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.
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.
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!
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!
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.
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.
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........
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!!!
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.
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
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!!
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
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.
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.
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!
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.
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.
Thanks for the video. But, there is an error in 4:02. Integer requires 2 bytes of memory and can store numbers from -32768 to 32767. -2M to 2M corresponds to Long (4 bytes).
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 UA-cam course. Thank you so much for all the hard work. And thank you everyone who adds new tricks in the comments.
Glad it was helpful!
I can't believe this content is free, the quality of the tutorials is just incredible !
Happy to hear that!
i was thinking the same!
@@Lethesys Me too!
@@LearnitTraining I feel always debt you a thank.
O
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.
Thank you for the kind words Boltage23!
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 .
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
Hey, is there tutorial that can explain how to create a data entry form on clicking a button generates a word doc?
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!
Sie sind herzlich willkommen! Danke für das Aufpassen!
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!
Awesome! Thank you!
@@LearnitTraining Hey, is there tutorial that can explain how to create a data entry form on clicking a button generates a word doc?
I am using brave browser to skip ads bruh 😂😂😂😂
@@hazelnuts590 send me the solution you found
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.
Glad it helped!
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:)...
I gained practical knowledge of Excel VBA through self-guided learning, utilizing various UA-cam 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.
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
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!
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.
Thank you so much for the kind words!
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.
You're very welcome!
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🥰👍👋
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.
Finished Beginner training yesterday now Advanced! Let's do this! :)
Oh yeah, I got hooked too :D:D
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 :)
I will just repeat previous opinion: The quality of the tutorials is just incredible! You are very talanted!
Wow, thank you!
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.
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").
Thank you for the kind words!
Such a brilliant course. The trainer is amazing!!! Its unbelievable that such content is free.
Thank you for watching!
The quality of this course is so high that I'm just shocked. THANK YOU SO MUCH FOR SHARING THIS!
You are very welcome!
This is the best VBA tutorial on UA-cam, straight forward very clear explanation .thank you for sharing it with us.
Thank you for watching and an extra big thank you for subscribing!
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.
Glad it helped!
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
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
This will sort the last column of first worksheet only.... not able to sort the rest of the worksheets... if you could help
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.
Hi Danh! Thank you so much! Sharing helps out a ton!
I am incredibly grateful for the creator of this course content.
Thank you for watching!
This is the best tutorial ever. I learned Python via tutorials but nothing was as well done as this course.
Glad you liked it!
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.
Thanks for sharing!
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.
Thank you for watching Manuel! We hope your new skills take you far!
@@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 is one of the best tutorial to learn VBA. Concepts are explained so precisely, keep up the good work
Thanks, will do!
Truly Amazing! I was very lucky to have found this channel. The tone, the pace, and the exercise files, everything is just top-notch.
Welcome aboard!
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.
Thank you for the great tips!
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!
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.
Thank you for watching baphnie and thank you for the tip!
Thank you for the great solution, better than ALL the others offered by experts who over-complicated their efforts.
You're welcome!
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.
Right!
May be the only option will be to declare as:
Dim Message As String, TitleBarTxt As String, DefaultTxt As String, SortVal As String
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.
Noted!
I can't thank you enough. It's such a good tutorial for everyone who wants to explore excel macros. Once again Hats off!
You're very welcome!
You're doing God's Work here. God Bless!!
You are welcome!
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.
Thank your Arun! Your continued feedback is always welcome!
Watched beginners last night and advanced tonight! Really appreciate these tutorials! Now Just need to practice and practice more.
You got this JP!
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!
I really like this instructor. She's very engaging.
Thanks!
@@LearnitTraining I recommended this video series to several coworker too.
One of the best tutorials for VBA...I actually learned a lot about VBA macro, from these videos..Thank you so much "Learnit Trainings"..
You are welcome!
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!
Thanks for watching Rahul! We hope you learned alot!
Excellent material for beginners to get a detailed and easy understanding of VBA.
brogrammer
Thank you for watching!
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.
As a Vietnamese, I am learning VBA and Ennglish Listening same time. Great on Covid stay home.
Best of luck!
This is what i wanted very crystal clear to the point explanation. Awesome I am going to refer this as my VBA bible.
Thank you for watching Bharat!
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.
Thank for the explanation.
Thank you for that!! I noticed the typo and was wondering how it still worked. Was hoping someone in the comments addressed it 🙏🏼
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........
You're very welcome!
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)
You are very welcome!
Excellent Madam.
God bless you forever. Be happy healthy. LOVE FROM INDIA.
Thank you
Thank you for your support Amit!
WOW! OUTSTANDING Tutorials. Exactly what I was looking for. You're a legend.
Thank you so much for the kind words Terry!
Godlike tutorials, finished the beginner one, onto the next
Glad you like them!
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
You're very welcome!
Your explanation is so simple and easy to follow. Thank you
You are welcome!
A truly helpful content....I got to learn so much within 4 to 5 hours. Thank you @Learnit Training for uploading such quality content.
Glad it was helpful!
Thanks very much for the lesson! It was absolute perfection! Despite being extremely difficult, I successfully persisted and have mastered perfectly!!!
Great job!
Chelsea Dohemann, you are an awesome teacher!!! Thanks for doing this video!
Glad it was helpful!
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.
Glad it was helpful!
I didn't have known that excel has so many functions like above video.
Thank you for those contents!
Happy to help!
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
Using the DEBUG feature of the ide is the best way to slowly go over someone elses code.
uno de los mejores cursos que he tomado...muchas gracias por este aporte
¡Gracias por mirar! Nos alegra que lo haya disfrutado!
Thank you for putting this content on UA-cam!
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!!
Thanks?
This video is awesome. I finally can understand and step by step write my VBA.
Thank you for the kind words L Teddy!
How is this content free!? I cannot express how much I love this content!
Thank you for watching Fahad! Hitting the like, subscribe, and sharing keeps the channel going!
@@LearnitTraining Sure!
Great series. Learned more here than other tutorials. Good pace, too. Thanks, Irv in Florida
Glad you enjoyed it!
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.
Possibly in the future
Thank you soo much Learnit ! beautiful training, so well organized, so well thought and just o the point !
You're so welcome!
Excellent high quality VBA Tutorials 👍👍👍
Thanks!
This is a very educational VBA video. I learned a lot from it. Thanks for putting it out for us to learn
For some non-obvious reasons I've always avoided VBA. No I won't no more. Thank you :)
Happy to help!
Merci d'avoir posté de telles vidéos. un travail très professionnel. Mille Merci
Merci d’avoir regardé!
Those projects were very fun & challenging, thank you! Heading to the next session :)
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
Thanks for the info!
Maybe…but I’ll tell ya, “declare in memory” made it make sense for me 😁
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.
Thanks for the tip!
Thank you so much for the tutorial. You explain very well with clear voice
You're very welcome!
Very clear and concise explanation! Thanks!
This tutorial is amazing. and thank you for inviting Kristen Bell as a voiceover!
You're so welcome!
Excellent tutorial. Extremely clear. Thanks so much.
You're very welcome!
Really good tutorial and really well laid out so easy to follow.
Glad it was helpful!
amazing tutorials. i am really glad they exist
Thank you for the kind words David!
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.
Amazing content! You made it look so easy to understand. Thank you!
You're very welcome!
Wonderful. Pure, effective and efficient learning
Many thanks!
I really love this tutorial... also the way it was explained... very easy to understand. -a beginer in the philippines!
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.
thank you for your supporting and helping
Thank you for watching!
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!
Thanks for the tip!
Great content. There are not word to describe how amazing it is.
Thank you for the kind words!
This tutorial is very helpful, thanks for the effort you have put to make these video
You're very welcome!
Great tutorial! Thank you so much Chelsea!
You are so welcome!
You exactly cound't have done it better! Perfect tuturial
Thanks so much!
Great and very well organized ...Thanks for your efforts
Most welcome 😊
Now Flexing for Expert Training! Thank You Learnit ; )
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.
Glad it was helpful!
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.
Thanks for the tip!
Thanks for this incredible tutorial !
You are very welcome Vivek!
Thanks for the video. But, there is an error in 4:02. Integer requires 2 bytes of memory and can store numbers from -32768 to 32767. -2M to 2M corresponds to Long (4 bytes).