These tutorials were excellent! Much appreciated Chelsea! Given the huge drop in views from Beginner to Expert video, I think everyone who finished all the way through deserves a round of applause too
Okay! When I started searching for excel vba courses on you tube I found videos of 10+ hours and some of just 3 hours. I avoided 3 hours video because I thought more topics would not be covered. The comments were good for all of them, then I found this video, approximately 7+ hours. I was like, how much can this lady cover in only 7 hours, but, since I had less time, I chose this you tube video. And I'm very much happy and impressed. All the topics which I wanted are covered and the lady has a very sweet voice. I learned a lot, used it to improve my daily work. Sorry for doubting you. My manager is happy, my team is happy, I'm also happy. Thank you so much for such great lessons.
@renukaangolkar2026 have you watched the complete series? This series of videos is really good. Also along with Excel VBA you need to have good knowledge in excle (formula, formatting etc) to be able to use it in your work.
Firstly Loving the courses so thank you !!! I had a issue with my Macro not changing data to Long date. For anyone else having issues at 13:21 this is how I fixed it (nothing was wrong with the code) The date formats including Long date is controlled by your pc settings. For Windows 10 go to Control Panel > Clock and Region Click Change date, time or number formats Then change Long date to dddd, dd MMMM yyyy (for the UK I guess it would be dddd, MMMM dd yyyy in the US) Below you will see examples of the formats you currently have selected. If you are happy with the changes click ok and your data should display in Excel as expected. It worked for me so hope this helps.
I have finally completed the entire course. This is one of the best courses I've taken so far. Your voice and teaching style definitely helps me in getting through the entire course more pleasurable. Thank you so much Chelsea!!
Thank you. And thanks again. For me, as a non-native English speaker, your explanation and way of speaking was fantastically understandable. Now I want to follow you and watch all your other videos, whatever they are about. So far the best tutorial for me, in my opinion.
Been watched all three videos in the series. Million thanks for sharing them. All stuffs are explained clearly and your voice is so pleasant to listen.
Thank to this course I am taken to another level in VBA. This course shows me different and broader perspective of how to use the VBA tools in practice. Thanks again for making this tutorial.
I know it’s kind of late, finding this video and comment, given it’s nearly 3 years since they posted. Watched through all 3 videos. really insightful. The video helped filled up some of my knowledge gaps, even having built some VBA projects already (mostly because I have learned Visual Basic from my studies and use Excel to solve many problem). Great explanations of codes so I understand them much better even when I already used some of them before. Really liked how the lessons gradually introduce objects/Methods in VBA to build up solving a real-world usable scenario. Had a thought across my mind. Around 51:03, if change the code as: Worksheets(y + 1).Name = Format(DateSerial(1, ((QuarterSelect - 1) * 3 + y), 1), "MMMM") The Sub can work as desired without the ‘Select Case QuarterSelect’ code block, saving a few lines of codes.
Excel VBA Expert Tutorial good in first half. Majority of the code recording has gone blurry hence gets annoyed at times. However, since codes are also available in practice files, really we don't miss anything. We expect a bit more in this expert series. Thank you for uploading and making it available to us.
Loving the videos and learning a lot. As a math guy, I chose to let QuarterSelect = QuarterSelect*3 - 2 which saved a few lines of code (though it didn't give the practice on Select Case.)
One faster code to do the excercise 16.Reordering sheets is: -Create a for loop to iterate across the worksheets and asking if left(woorksheet(i).name, 2) = "SE" then move. The left function extract the first n characters of a string
A fun thing to do for the reorganizing sheets one is to first finish the macros started for sorting the desired region to the front. Then you can record a macro while you create buttons for them on the first sheet, then call this macro to apply the buttons to all Th sheets with one command. Super satisfying!
Hi learnit! I love the Tutorials. Im from the Philippines by the way. You have a very clear way of speaking thats why i like it. I understand every words and steps! More Tutorials about vba specially creating data forms for our school.
Thanks for the video. I'd learned a lot on Excel VBA. However, I encountered an issue on the 18.Move, Copy and Print based on User Input.xlsm Macro. For example, when I entered 5 in the InputBox("Which Quarter is this for?"), yes, it indeeds ask user to "Try Again". This time I enter the correct Quarter number, it did create Quarter sheets but it also created additional sheets; May, Jun & Jul. I found out strangely that it loops back to: For y = 1 To 3 Worksheets(1).Copy After:=Worksheets(y) Worksheets(y + 1).Name = Format(DateSerial(1, QuarterSelect + y - 1, 1), "MMMM") Next y
First of all, thank you so much for this wonderful training! I did all 3 (beginner, advanced, expert), and they are all great. In this last part however the macro suggested in part5 runs into an error. When the quarter selection is incorrect, and the user confirms that they will try again, and the second time enter a correct quarter number, then for some reason the macro executes the part after the 'end if' twice, and the second time results an error. I managed to fix it by breaking the macro to two pieces, the first one is only the select case + the if part, and the second the actual loop, and a 'main' macro that calls both after each other. I wonder if there is a better way of doing this?
Some of your dim statements do not behave as you expect. For instance the statement: Dim X, Y as integer defines two variables, X and Y. However, Y is defined as the desired integer while X is defined as a variant. This can be confirmed in the Locals window. Variants work, but require more system resources. A better syntax is: Dim X as integer, Y as integer This defines both X and Y as integers.
Woa, very interesting how much VBA works with Excel. I learned a lot. Thanks thanks thanks. I personally do not think subscriptions are healthy for humanity, but I do believe in donations / commissions / contributions. I will look for a way to donate. Hope that is available.
The date Format didn't work for me, and I notice in the video, you don't show us it has worked for you, because you din't change the formatting to "general" as you had done earlier.
Thank you for the immense amount of help. But can anyone explain why every month is October when i try to run the 12 month calendar macro? I'm probably missing something obvious but I would appreciate any help on this issue
Hi just started looking at your tutorials, i am 75 and looking to expand my understanding of excel, my problem is I wish to import live data from 5 web sites, and run them in a worksheet, so I find the lowest cost. Can you please inform me of the correct course to be viewing. thank you
Here is a technique from another medium. Grab the 1st date of the NEXT Month and subtract "1" from it to get the last date of the CURRENT MONTH to use in your For/Next loop
Hi I just finished the last video And for some reason, my last answer (house surface area) is 1445.22, instead of 1468 as shown in the video. I looked at my function and compared it to the one in the video - the same thing exactly (the only difference is the order of the variables in the declaration) please help me
Hi! Thanks so much for providing these wonderful tutorials. I have an issue with the 18. Moe, Copy and Print workbook, where I was working on the ALargeMacroExample module "DuplicateMonthlyLog" function, and the line " Worksheets(1).Copy After:=Worksheets(x)" keeps throwing an error 1004 and "Path/file" error, saying that this worksheet cannot be copied. Has anyone else encountered this, and how should one go about fixing it? Thanks!
Finished all the three videos, I just want to send a huge thanks to all of you, I have learned a LOT
Hey i was watching first video can you please tell me how can i downlod simple macro?
@@madhavsuneja5968 in the description of the video, contains a link called exercise files, dl that file and search for simple macros
I ve just finished the first two, now I start the third.
Mooin
me too
These tutorials were excellent! Much appreciated Chelsea! Given the huge drop in views from Beginner to Expert video, I think everyone who finished all the way through deserves a round of applause too
You're so welcome!
@@LearnitTraining Thank you so much!! One of the best tutorial series I've ever done!
Okay! When I started searching for excel vba courses on you tube I found videos of 10+ hours and some of just 3 hours. I avoided 3 hours video because I thought more topics would not be covered. The comments were good for all of them, then I found this video, approximately 7+ hours. I was like, how much can this lady cover in only 7 hours, but, since I had less time, I chose this you tube video. And I'm very much happy and impressed. All the topics which I wanted are covered and the lady has a very sweet voice. I learned a lot, used it to improve my daily work. Sorry for doubting you. My manager is happy, my team is happy, I'm also happy. Thank you so much for such great lessons.
@renukaangolkar2026 have you watched the complete series? This series of videos is really good. Also along with Excel VBA you need to have good knowledge in excle (formula, formatting etc) to be able to use it in your work.
I've also watched other tutorials from LearniIT, but Chelsea has done a great job. Her speech is clear and to the point. She is a great instructor
We think Chelsea is great too!
Firstly Loving the courses so thank you !!!
I had a issue with my Macro not changing data to Long date. For anyone else having issues at 13:21 this is how I fixed it (nothing was wrong with the code)
The date formats including Long date is controlled by your pc settings.
For Windows 10 go to Control Panel > Clock and Region
Click Change date, time or number formats
Then change Long date to dddd, dd MMMM yyyy (for the UK I guess it would be dddd, MMMM dd yyyy in the US)
Below you will see examples of the formats you currently have selected.
If you are happy with the changes click ok and your data should display in Excel as expected.
It worked for me so hope this helps.
Thank you for the tip, Lou! Also thank you for your support!
Thank you so much for the tip!! this had confused me a lot
Thank you bro I stuck 1 hour there
I have finally completed the entire course. This is one of the best courses I've taken so far. Your voice and teaching style definitely helps me in getting through the entire course more pleasurable. Thank you so much Chelsea!!
Thank you for the kind words!~
Just finished all the 3 videos, and I must send a huge thanks to all of you.
The tutorials are very well explained and organized.
Thanks a lot!
Glad you like them!
Chelsea, I want to thank you for your time and the resource you have put in here. This has been really useful to get the VBA fundamentals going for me
thanks for these detailed, to-the-point videos
Glad you like them!
I just finished the 3 videos and I learned a lot. I will explore VBA on my own now that I have better tools to do it. Thank you very much Chelsea!
Thank you so much Maria and an extra thank you for subscribing! It helps so much!
Thank you so much for these wonderful 3 videos. Please do more examples of the use of VBA in data analysis. Thank you.
You are very welcome!
Thank you Chelsea for the courses! Your teaching style is also great and easy to follow along with. Much appreciated.
You're so welcome!
I just Finished all three videos. Thanks a lot. Learning VBA is so cool.
Thank you. And thanks again. For me, as a non-native English speaker, your explanation and way of speaking was fantastically understandable. Now I want to follow you and watch all your other videos, whatever they are about. So far the best tutorial for me, in my opinion.
You're very welcome!
I would like to thank you for creating this amazing tutorial. I have completed the complete course/ Now, I am very confident.
Great to hear!
I feel more confident after going thru 3 video's. Excellent. Thanks a lot.
Excellent!
Thank you very much for this video series on Excel VBA. It was really helpful to grasp the different aspects of the subject in depth.
You are most welcome!
I love the way you Teach and speak. awesome Ms. Chelsea. Kudos
Been watched all three videos in the series. Million thanks for sharing them. All stuffs are explained clearly and your voice is so pleasant to listen.
Thank you for the kind words Luki!
Thank to this course I am taken to another level in VBA. This course shows me different and broader perspective of how to use the VBA tools in practice. Thanks again for making this tutorial.
You're very welcome!
Great and outstanding performance, outstanding and complete materials; presentation, documnets and Exercise Files.Thanks
You are welcome!
Thank you. I finally finished the previous two videos.
You are welcome!
Thanks so much, finished them all, really easy to understand. I've already can write my own macro for my work.
Thank you for watching Ngoc! We are glad you learned so much!
The three tutorials were perfect. Learned a lot. Much appreciated!
Glad you like them!
I enjoyed every single bit of this training program
Thank you so much for watching!
Really appreciate your efforts in making these amazing tutorials, thank you LearnIt Team!
Glad you like them!
I have completed the entire course. This has been wonderful. Chelsea, you are an awesome teacher !
Thank you! This video is really clear and very organized! It makes me feel confident about VBA now~
Glad it was helpful!
Thanks for guiding us through the whole time (for 3 times)! I have learnt a big ton and it was so satisfying!
You are so welcome!
thank you very much Chelsea! you are awesome!
You're so welcome!
Thank you so much. Its been one of the best courses I have taken.
You are very welcome!
The three videos will be so useful! Many thanks Chelsea for your explanations! I can't wait to create my own macros!
You're so welcome!
Really appreciate the team and your effort in making these awesome videos!
Our pleasure!
Thanks a lot to learnit for giving such an tremendous excel VBA course for free specially thanks to @Chelsea Dohemann.Takes Love.
You're very welcome!
Amazing video series, I've learned so much for this channel, I appreciate all the material and guidence!
You are welcome!
I know it’s kind of late, finding this video and comment, given it’s nearly 3 years since they posted.
Watched through all 3 videos. really insightful. The video helped filled up some of my knowledge gaps, even having built some VBA projects already (mostly because I have learned Visual Basic from my studies and use Excel to solve many problem).
Great explanations of codes so I understand them much better even when I already used some of them before. Really liked how the lessons gradually introduce objects/Methods in VBA to build up solving a real-world usable scenario.
Had a thought across my mind. Around 51:03, if change the code as:
Worksheets(y + 1).Name = Format(DateSerial(1, ((QuarterSelect - 1) * 3 + y), 1), "MMMM")
The Sub can work as desired without the ‘Select Case QuarterSelect’ code block, saving a few lines of codes.
Thank you so much for the kind words! Also thank you so much for the great tip!
Thank you for all the learning you gave, i am simply amazed by the things I knew before watching this video, and now after watching it. Thanks alot
You're very welcome!
Chelsea thank you for your time and the resource you have put in here. i learned a lot from you. thank you
You're so welcome!
Just Amazing how much you learn from these 3 video parts. Well done.
Glad you like them!
Excel VBA Expert Tutorial good in first half. Majority of the code recording has gone blurry hence gets annoyed at times. However, since codes are also available in practice files, really we don't miss anything. We expect a bit more in this expert series. Thank you for uploading and making it available to us.
Thank you for this excellent piece of artwork!
madam please upload more vba tutorial I am learning by watching your videos. I am from India.great thanks to you.
Thank you very much for putting together these free tutorials. Really really helpful!!!
You're very welcome!
All parts of this tutorial are great. Thanks guys for sharing it with us!
Our pleasure!
Thanks for this great tutorial. all the best!
Thank for your continued support mohamad!
Sorryfor gettting your name wrong - Chelsea Dohmann You are a fantastic teacher Hats off to you Long may you continue this work Chao
Thanks Chelsea Its really nice way to explaining each and every points in VBA . Learn a lot from these videos .
Chelsea is a badass teacher and used to drive el camino!
Hi Joseph - Thank you for the kind words!
Loving the videos and learning a lot. As a math guy, I chose to let QuarterSelect = QuarterSelect*3 - 2 which saved a few lines of code (though it didn't give the practice on Select Case.)
you probably meant QuarterSelect = (QuarterSelect*3) - 3 + y
Thanks a lot for making Excel VBA tutorials
You are most welcome!
Awesome work by Chelsea
Thank for the kind words Bobby!
Thankyou for the VBA training, excellent teaching and materials! Hoping for the next VBA tutorial ..
Thank you for watching Yosafat!
Thanks for the VBA tutorial series!
One faster code to do the excercise 16.Reordering sheets is:
-Create a for loop to iterate across the worksheets and asking if left(woorksheet(i).name, 2) = "SE" then move. The left function extract the first n characters of a string
A fun thing to do for the reorganizing sheets one is to first finish the macros started for sorting the desired region to the front. Then you can record a macro while you create buttons for them on the first sheet, then call this macro to apply the buttons to all Th sheets with one command. Super satisfying!
really , thank for your effort, exquisite explanation
Thank you for watching!
Thanks A Lot Maam these session are really amazing to learn
You are very welcome!
Thanks! All three lessons helped me a lot!
You're very welcome!
Just to let you guys know, i charged 25$ (15k in my country) for explaining things that I've learned in this video, thanks!
You are very welcome Joseph!
Hola Chelsea.
Me encantaron tus tres videos de Excel Vba
¿Cuándo tendrás tres más?
MIl gracias
Great content and advanced teaching skills. Thanks Madam.
It's our pleasure!
Absolutely magnificent tutorials! And I'm definately subscribing to your channel because your content is amazing.
Thank you so much Dušan Terek ml! It helps us to continue to make videos for everyone!
Thanks for the free course finished all 3 videos and I really appreciate your teaching God bless @chelsea Dohemann and learnIt
Thank You Chelsea ...It Is so Amazing
Thank you for watching The Peaceful!
Good insights gained here.
Thank you for the kind words!
Extremely well explained. Thanks a ton
Glad it was helpful!
Hi learnit! I love the Tutorials. Im from the Philippines by the way. You have a very clear way of speaking thats why i like it. I understand every words and steps! More Tutorials about vba specially creating data forms for our school.
Thank you so much for this tutorial! It taught me a lot!
You're very welcome!
THank you for the training! Living in FL from the Chico/Paradise area.
Our pleasure!
Very nice tutorial
Thank you! Cheers!
Seriously recommended, nice work. Keep it up.
Thanks, will do!
Completed! Thank you :)
These videos are definitely useful and timeless.
Thank you so much for the recap, you’re such a coherent and understandable tutor ☺️
You are very welcome! 😊
Thank you very much. I ve learnt a lot.
Glad it was helpful!
Thank you so much for your help and your time!
Hi Leon! Thank you for watching and an extra big thank you for subscribing!
MsgBox("Thank you for this course :-")
Thank you for watching and your continued support Vivek!
Thank you so much Chelsea
great video
Glad you enjoyed it!
Thanks for the video. I'd learned a lot on Excel VBA.
However, I encountered an issue on the 18.Move, Copy and Print based on User Input.xlsm Macro.
For example, when I entered 5 in the InputBox("Which Quarter is this for?"), yes, it indeeds ask user to "Try Again". This time I enter the correct Quarter number, it did create Quarter sheets but it also created additional sheets; May, Jun & Jul. I found out strangely that it loops back to:
For y = 1 To 3
Worksheets(1).Copy After:=Worksheets(y)
Worksheets(y + 1).Name = Format(DateSerial(1, QuarterSelect + y - 1, 1), "MMMM")
Next y
Unfortunately, the variable "Quarter Select" does not work correctly.
Thank you. Very useful.
Thank you
You're welcome
Thanks
You are very welcome!
First of all, thank you so much for this wonderful training! I did all 3 (beginner, advanced, expert), and they are all great.
In this last part however the macro suggested in part5 runs into an error. When the quarter selection is incorrect, and the user confirms that they will try again, and the second time enter a correct quarter number, then for some reason the macro executes the part after the 'end if' twice, and the second time results an error. I managed to fix it by breaking the macro to two pieces, the first one is only the select case + the if part, and the second the actual loop, and a 'main' macro that calls both after each other. I wonder if there is a better way of doing this?
Some of your dim statements do not behave as you expect. For instance the statement:
Dim X, Y as integer
defines two variables, X and Y. However, Y is defined as the desired integer while X is defined as a variant. This can be confirmed in the Locals window. Variants work, but require more system resources. A better syntax is:
Dim X as integer, Y as integer
This defines both X and Y as integers.
Thanks for the tips!
Thank you Easy to follow and understand
Very good!
Thanks!
Great!
Thank you for watching!
Nice video❤️
Thanks 😁
wow you are amazing you teaching way is very nice we are enjoying you youtub vba class
*GREAT* *Thank you for sharing*
Woa, very interesting how much VBA works with Excel. I learned a lot. Thanks thanks thanks. I personally do not think subscriptions are healthy for humanity, but I do believe in donations / commissions / contributions. I will look for a way to donate. Hope that is available.
Thank you TDT! Just sharing our videos and channels is the best way to help!
The date Format didn't work for me, and I notice in the video, you don't show us it has worked for you, because you din't change the formatting to "general" as you had done earlier.
great videos!
Glad you like them!
Great content!!! I just finished going through each of the three videos while doing the exercises too. Chelsea u sure know ur stuff
Awesome! Thank you!
Before these videos, I had no Idea that Excel could do so much. I'm losing my mind. Thank you for sharing.
Thank you for the immense amount of help. But can anyone explain why every month is October when i try to run the 12 month calendar macro? I'm probably missing something obvious but I would appreciate any help on this issue
Hi just started looking at your tutorials, i am 75 and looking to expand my understanding of excel, my problem is I wish to import live data from 5 web sites, and run them in a worksheet, so I find the lowest cost. Can you please inform me of the correct course to be viewing. thank you
Power BI would be the program to use for that type of data visualization and we have many videos on Power BI on our channel
@@LearnitTraining Thank you for your help
Here is a technique from another medium. Grab the 1st date of the NEXT Month and subtract "1" from it to get the last date of the CURRENT MONTH to use in your For/Next loop
Great technique and thank you for sharing!
Hi
I just finished the last video
And for some reason, my last answer (house surface area) is 1445.22, instead of 1468 as shown in the video.
I looked at my function and compared it to the one in the video - the same thing exactly
(the only difference is the order of the variables in the declaration)
please help me
Hi! Thanks so much for providing these wonderful tutorials. I have an issue with the 18. Moe, Copy and Print workbook, where I was working on the ALargeMacroExample module "DuplicateMonthlyLog" function, and the line " Worksheets(1).Copy After:=Worksheets(x)" keeps throwing an error 1004 and "Path/file" error, saying that this worksheet cannot be copied. Has anyone else encountered this, and how should one go about fixing it? Thanks!
Hi Olina! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com