+Alison D You're very welcome Alison, good luck with the qualification! Take a look at our Excel VBA for Post-Beginners series too - link in video description above.
It's 2020 and your videos are STILL current and extremely well thought out and delivered in such a way that even an 80 year old man commented he understood the whole process. You're a good man and I thank you for the video!
Joshua - thank you so much for the kind comment, and great to hear you are getting into code now. I consider myself a late starter having not started until my late 20s! Good luck and let me know how you get on - many more videos on the channel to work through.
These videos are awesome! At first, when I heard his accent, I thought it would be difficult to understand him - but not at all! He is so thorough and easy to understand. Looking forward to learning more from him!
Yesterday, I was stumped with something I needed to do for work. Thanks to your videos, I just finished writing a macro that does the job. Thanks very much!
I like the way you presented these four videos. You establish the necessary level of comprehension needed to bring context to the abstract appearance coding. I am currently on light duty due to an accident I was in and was assigned the task to write Macro that can import data from an external source and remove irrelevant information and .replace ".", "." . I have no coding experience so your videos are a gift from heaven.
Thanks for this series.... I'm the youngest employee in my office who is using excel VBA... I want to learn how to automate some repetitive tasks in excel..... your videos are really helpful...
Hi Komal - great to hear the videos are helping, and that you've been able to solve some real-life problems. I hope you'll keep coming back to the channel through your career. Good luck!
Many thanks Juho. You're right - code is scary to begin with, but if you can gradually shift your mindset into one of 'play', the sky is the limit! Good luck.
Tiger Spreadsheet Solutions Indeed! I can't get my head around the fact that some kind person helps me with productivity and eventually, effectiveness. And just with a prize of like and sub! 🏆
I really liked the way you have explained in videos. Your attention towards detailing like aligning the buttons really helps a lot. Thank you. Looking forward for your videos on advanced coding in VBA
Thank you this was very useful. I've been financial modelling for 3 years now, and have recently encountered situations where macros have been necessary. These are the best beginner level videos that I've seen. Thank you!
This is great stuff, I'm using excel everyday and heavily rely on formulas but VBA has always eluded me, this explains it really well in bit sized pieces.
This is the epitome of excellent teaching. Super clear. A little slow-paced if one is already familiar with some basics but nonetheless super neat. Thank you so much for sharing your knowledge
As many others I found the confidence in VBA through these videos. Thanks alot! What I don't get, is the counter/loop is supposed to go through the routine and execute the code 10 times. However it goes from 0-10 which equals 11 loops.
Hi Mikkel - thank you. I am not absolutely sure why I first went from 0 to 10 which, as you correctly point out, equals 11 loops. Some small tweaks to the code can achieve the desired effect, however. Make sure you check out our other videos and good luck with your VBA!
Thanks alot, I researched a bit, and found that the counter runs from 0-10, also saying so in the code. however if you change it to 1-10 it runs 1,2,3,4,5,6,7,8,9,10 which eventually equals 10 loops.
Just an additional remark, you do also say in the video that when counter hits 10 it doesn't enter the loop and exists straight away. However, it does run the loop once more and only when it is 11 (and hence outside the bounds of the loop range) the code in the loop isn't run any longer and the code jumps to the first line of code after the loop.
These videos are amazing, you just refreshed my VB skills with excels. its very easy to understand it will definately help me with my excel with with accounting skills. God bless you
Very informative series of videos, thank you for explaining in a clear and precise manner. Although one mistake I spotted was that if you want to run the loop 10 times and that you are starting from 0 then your finishing number would be 9.
Hey Chris, Hope u r doing great... I really found your videos quite explainatory.. The way you explain makes it really easy for me to grasp and work on it. Though am not from the coding, programming back ground; I have developed a kind of interest in to VB..
You just got another subscriber for being so precise and clear in teaching. You got perfect skills in conveying a subject to the learner. I need to learn more on Macros & VBA in creating advanced forms/formatting , reports and automated mailing. Please let me know if you have more learning material.
You are an incredibly good instructor. Thank you for your crystal clear tutorial. I shall pursue your more advance videos. By the way, your teaching style is very good, reassuring, and calming. Bravo!
Many thanks Rajdeep. I think the only way is to 'practise, practise, practise'! And be prepared for when it goes wrong. So, I would say the 'proper way' is being committed (to practise) and resilient (to keep going when it goes wrong).
Wow these 4 videos are very helpful. Even though I'm using Microsoft Excel 2016 on mac which is a little bet difference but I got them all. thank you so much
Hello,I just want to say Thank you cause your vídeo helped me so much. I'm trying to learn VBA code and the vídeo is very quickly and simple to undestand.I'm from Brazil so r able to say, your VBA course are crossing the oceans. KiddingCya.
All 4 videos are awesome and very well explained. I did everything as explained and was successful, will need to improve now. But this was a very good starting point. Appreciate the videos. Keep up the good work Tiger.
Just a suggestion to do more loop videos covering do while, do until, for each next loops, whilst also discussing on when to use pre and post-test loops!
since we keep saying, "Presentation is everything," I changed up the vba code a little bit (this is how I learn) to make sure the list starts in the cell you want it to, then as the counter moves the cell selection, I wanted to ensure that the format of the cell is centered. (Selection.HorizontalAlignment = xlCenter). should look like this: Sub MakeList()
'first put the cell selection in the right place 'for the list ActiveSheet.Range("E5").Select
'declare variable for our loop counter Dim counter As Integer
'set up the for/next loop For counter = 0 To 10
'set the cell format to center the text Selection.HorizontalAlignment = xlCenter
'set the value of selected cell to value of counter variable Selection.Value = counter
'move the cell selection down one cell Selection.Offset(1, 0).Select
Hi David - I have never used a book but I know there are plenty on the market. I could not recommend a particular one though. I would say that if you work through our VBA for beginners playlist you will have an excellent foundation. Good luck!
Easy peasy! Now, how would you go about a Loop to go from zero (0 = initial position) to n-th position based MsgBox, InputBox, another Loop? Thank you for your time and assistance!
Great videos, was able to play around with the coding and do different things within minutes. Trying to expand my skill set so this a great start ! Nice and short videos too :)
All I need is the basics to Understand the coding; for eg. you have used Dim, Show, Unload etc. I want to understand this concept, which will make me write codings in future easily.. Do you have any such video explaining the coding language. Thanks in Advance. Really appreciate your videos, hats off to you for your way of educating people... Cheers....
Hi Mohammed - you can see all of my videos on this channel. Most of them are practical (not theoretical) in focus, but I think that really is the best way to learn coding. Good luck!
I Totally agree with Alison D comments Below I have been doing it all wrong I've learned so much from your video going along with everything you did on the excel spreadsheet went fine and I learned so much can you Help Me A little problem I have How can I write a simple VBA When I click on a box it will enter a 3 digits number then when I click on it again it will Move Down to the next cell to repeat the same process Hope you can help. Thanks :-)
Very good introduction to VBA Programming all love your channel. Nevertheless, for those who are more book learners, which book on VBA programming do you suggest? In my case, I have financial / investment / business intelligence applications in mind (financial projections, financial statement modeling, simple portfolio analysis, stock screeners etc).
![[#2024MAMA] G-DRAGON - 무제(Untitled, 2014)+POWER+HOME SWEET HOME+뱅뱅뱅+FANTASTIC BABY | Mnet 241123 방송](http://i.ytimg.com/vi/Ox29z5Nf1Uk/mqdefault.jpg)
These videos are so helpful. I'm studying for an advanced Excel qualification and these are clear and well explained tutorials. Thanks :-)
+Alison D You're very welcome Alison, good luck with the qualification! Take a look at our Excel VBA for Post-Beginners series too - link in video description above.
It's 2020 and your videos are STILL current and extremely well thought out and delivered in such a way that even an 80 year old man commented he understood the whole process. You're a good man and I thank you for the video!
Joshua - thank you so much for the kind comment, and great to hear you are getting into code now. I consider myself a late starter having not started until my late 20s! Good luck and let me know how you get on - many more videos on the channel to work through.
You're an incredibly effective teacher. Well done!
These videos are awesome! At first, when I heard his accent, I thought it would be difficult to understand him - but not at all! He is so thorough and easy to understand. Looking forward to learning more from him!
Sue - glad you were able to understand! Many more videos on the channel, hope you find them helpful.
Yesterday, I was stumped with something I needed to do for work. Thanks to your videos, I just finished writing a macro that does the job. Thanks very much!
Fantastic stuff William, well done! Do check out the other videos on the channel.
I like the way you presented these four videos. You establish the necessary level of comprehension needed to bring context to the abstract appearance coding. I am currently on light duty due to an accident I was in and was assigned the task to write Macro that can import data from an external source and remove irrelevant information and .replace ".", "." . I have no coding experience so your videos are a gift from heaven.
Good to hear Ryno. Plenty more coding videos on the channel. Good luck!
I can say one of the best VBA videos for dummies on YT...
Great to hear! Many more videos to watch on the channel ...
Thanks for this series.... I'm the youngest employee in my office who is using excel VBA... I want to learn how to automate some repetitive tasks in excel..... your videos are really helpful...
Hi Komal - great to hear the videos are helping, and that you've been able to solve some real-life problems. I hope you'll keep coming back to the channel through your career. Good luck!
Taking on the VBA from scratch seems less taunting after the four videos. Superb and generous work with the videos!
Many thanks Juho. You're right - code is scary to begin with, but if you can gradually shift your mindset into one of 'play', the sky is the limit! Good luck.
Tiger Spreadsheet Solutions
Indeed! I can't get my head around the fact that some kind person helps me with productivity and eventually, effectiveness. And just with a prize of like and sub! 🏆
A friend told me they were using this- I wanted to learn some for myself and these are incredibly clear and helpful!
Thank you and a big welcome to the channel - please check out the other videos series. Have fun!
This guy is brilliant. If i had lecturers such as him; I might have majored in two principles!
I really liked the way you have explained in videos. Your attention towards detailing like aligning the buttons really helps a lot. Thank you. Looking forward for your videos on advanced coding in VBA
Thank you this was very useful. I've been financial modelling for 3 years now, and have recently encountered situations where macros have been necessary. These are the best beginner level videos that I've seen. Thank you!
Great to hear Nayab and welcome - do check out the other videos on the channel.
You're a great teacher and lifesaver. Thank you so much!!
This is great stuff, I'm using excel everyday and heavily rely on formulas but VBA has always eluded me, this explains it really well in bit sized pieces.
Great to hear SP - I hope you'll be able to integrate VBA into your daily usage
@@TigerSpreadsheetSolutions thanks man, I'm on to the post beginner series now
Keep up the good work! Let me know how you get on.
Excellent tuition. I normally struggle but you were so clear. This is terrifying for a beginner but you took away some myths.
Great to hear my friend, welcome to the channel. Nottingham half marathon in September!
This is the epitome of excellent teaching. Super clear. A little slow-paced if one is already familiar with some basics but nonetheless super neat. Thank you so much for sharing your knowledge
Thank you and welcome to the channel - our more recent videos are bit faster paced ...
As many others I found the confidence in VBA through these videos. Thanks alot! What I don't get, is the counter/loop is supposed to go through the routine and execute the code 10 times. However it goes from 0-10 which equals 11 loops.
Hi Mikkel - thank you. I am not absolutely sure why I first went from 0 to 10 which, as you correctly point out, equals 11 loops. Some small tweaks to the code can achieve the desired effect, however. Make sure you check out our other videos and good luck with your VBA!
Thanks alot, I researched a bit, and found that the counter runs from 0-10, also saying so in the code. however if you change it to 1-10 it runs 1,2,3,4,5,6,7,8,9,10 which eventually equals 10 loops.
Just an additional remark, you do also say in the video that when counter hits 10 it doesn't enter the loop and exists straight away. However, it does run the loop once more and only when it is 11 (and hence outside the bounds of the loop range) the code in the loop isn't run any longer and the code jumps to the first line of code after the loop.
Your VBA for beginners videos have been extremely helpful. I concur with a comment below, you are an incredibly effective teacher - thank you !
Fantastic to hear Geoff - I hope you'll push on with some of the other videos too, let me know your questions!
Gifted instructor clearly teaching these concepts. Thank you.
It's a pleasure, Robert!
Great introduction ! Wonderful ! I've watched the 4 videos in a row ! Thanks so much !
It's a pleasure Ahmed, good luck!
These videos are amazing, you just refreshed my VB skills with excels. its very easy to understand it will definately help me with my excel with with accounting skills.
God bless you
Many thanks Raheel - good luck with your coding :-)
Now i have gained some confidence in macro coding...Awsome..I wish u have some more Advanced Macro lectures..thanks a lot
Hi Mohammad, thank you for the comment, more coding videos are coming soon...
Your teaching skills are 99/100 wow! amazing! thanks!
Suleyman - but how do I get that last mark?! Thank you!
Very informative series of videos, thank you for explaining in a clear and precise manner. Although one mistake I spotted was that if you want to run the loop 10 times and that you are starting from 0 then your finishing number would be 9.
Meph - you're absolutely right. I can do VBA but manual counting in my head ... still struggle with that.
Hey Chris, Hope u r doing great... I really found your videos quite explainatory.. The way you explain makes it really easy for me to grasp and work on it.
Though am not from the coding, programming back ground; I have developed a kind of interest in to VB..
You just got another subscriber for being so precise and clear in teaching. You got perfect skills in conveying a subject to the learner. I need to learn more on Macros & VBA in creating advanced forms/formatting , reports and automated mailing. Please let me know if you have more learning material.
Hi there, many thanks - there are 100+ videos on the channel, many with download files. for you to work though. Good luck!
these videos are giving us clear information about the basic information of VBA macros in excel.I really liked it .thanks
Good to hear you found them useful Santosh - please do share them! See you in another video on the channel.
Thank you so much for this course! I am taking a course at Uni and this was so helpful, well explained and even really fun content! Appreciate it.
Many thanks Camila :-)
You are an incredibly good instructor. Thank you for your crystal clear tutorial. I shall pursue your more advance videos. By the way, your teaching style is very good, reassuring, and calming. Bravo!
Thank you Thomas and good luck!
Fantastic videos, very easy to understand and well spoken. Excellent
+jdkco Thank you - glad the videos helped :-)
So helpful lecture! I have just started VBA and could follow all of your 4 beginners videos. Thank you
Tilak - good to hear, don't forget to check out the rest of the VBA for Beginners playlist.
Hi, your tutorials are excellent. You are a great teacher.
Could you tell me what is the proper way to master the excel VBA codes/commands etc
Many thanks Rajdeep. I think the only way is to 'practise, practise, practise'! And be prepared for when it goes wrong. So, I would say the 'proper way' is being committed (to practise) and resilient (to keep going when it goes wrong).
Dear Sir you 4 videos explained about VBA are superb...your explanation its too good to understand for beginners.
Many thanks and good luck with your coding!
Too Good ! Lucidly explained the basics of VB. Love to see more on this . Many Thanks
Thanks for watching and do check out the other videos on the channel
Dear Mr Tiger,
Your videos were awesome. Thank you very much
Wow these 4 videos are very helpful. Even though I'm using Microsoft Excel 2016 on mac which is a little bet difference but I got them all. thank you so much
Good to hear Mohammed. In my experience, about 95% of code developed on PC works on Mac, with a few annoying exceptions.
Excellent video! Step by step to understand clearly how it works. Thank you very much.
You're welcome Mauro!
Thank you , Extraordinary Explanations!
Hello,I just want to say Thank you cause your vídeo helped me so much. I'm trying to learn VBA code and the vídeo is very quickly and simple to undestand.I'm from Brazil so r able to say, your VBA course are crossing the oceans. KiddingCya.
+Guilherme Molero Müzel You're very welcome Guilherme, glad to hear that the videos are helping! Good luck with your coding.
All 4 videos are awesome and very well explained. I did everything as explained and was successful, will need to improve now. But this was a very good starting point. Appreciate the videos. Keep up the good work Tiger.
Thanks Andris - plenty more videos for you to work through on the channel. Good luck!
Beautiful little series, thank you very much :)
Thanks for this Video. It's helped me a lot to understand what I'm doing so much better
+Qpc toyin Thanks - and good luck with your coding. Don't forget to take a look at the Post-Beginner series too ... :-)
I like the method of explaining so simply and effectively. Cheers
Thanks for the comment, Hafiz!
Just a suggestion to do more loop videos covering do while, do until, for each next loops, whilst also discussing on when to use pre and post-test loops!
Thanks for feedback Danny, I particularly like the pre- / post-test loops idea - that would be fun to demystify :-)
Looking forward to it! Your videos are most engaging, cheers!
since we keep saying, "Presentation is everything," I changed up the vba code a little bit (this is how I learn) to make sure the list starts in the cell you want it to, then as the counter moves the cell selection, I wanted to ensure that the format of the cell is centered. (Selection.HorizontalAlignment = xlCenter). should look like this:
Sub MakeList()
'first put the cell selection in the right place
'for the list
ActiveSheet.Range("E5").Select
'declare variable for our loop counter
Dim counter As Integer
'set up the for/next loop
For counter = 0 To 10
'set the cell format to center the text
Selection.HorizontalAlignment = xlCenter
'set the value of selected cell to value of counter variable
Selection.Value = counter
'move the cell selection down one cell
Selection.Offset(1, 0).Select
Next counter
End Sub
Nicely done, Charles 👍
Thank you so much for these videos, they are great! It makes me wonder why we don't use VBA simultaneously with teaching algebra.
It's a pleasure and yes, I like the idea very much. Both require clear logical thinking I suppose. Good luck!
I got the answer, sorry about the silly question. I watched the video again and got it. Thanks !!!! superb videos
Good to hear Deepali!
U R A WONDERFULL TEACHER I HAVE EVER SEEN FOR MY LIFE, THNKS FOR UR HELPING.
Thank you and welcome to the channel!
Merci beaucoup. Your explanations are chrystal clear.
De rien, Jean! Good luck on your coding journey and do check out our other coding videos.
Thank you so much for the 4 video tutorial. You gave me a great understanding of VBA.
Good to hear CJ!
Such a nice way of teaching. Thank you so much for the video
Many thanks Vikas - please do share the videos if you like them!
Good Job Man! You have explained it nicely. Moving onto Post-Beginners lessons.
very nice and easy tutorials.
helped to learning basic of VBA so quickly.
thanks a lot
+Drc John You're very welcome John - good luck with your coding
Hi Tiger, thanks for tutorials You are an excellent teacher, Thanks a lot.
You're very welcome - please do share the videos with somebody else whom they might help.
Thank you soo much for simple and clear explanation
That great i am looking for this lesson long time now i got it thank you so much for your sharing
Great lectures Tiger! Now I too can say I know something about excel! Ready for post beginners! thanks
Thanks Kelvin, and good luck with the rest of the videos!
Thank you, Simple and comprehensive explanation.
Thank you Priya - do check out the other video series on the channel ...
Great stuff, explained patiently, repetitively, easy to remember. Keep it up Tiger ! (: J.C. from Canada
Many thanks JC - please check out the other videos on the channel!
Thank you so much for the videos and all the effort. You explained everything in a very simple and amazing way.
Wish you all the success :)
+Mudit Bareja Thank you Mudit! Good luck with the coding, and don't forget to check out our post-beginner VBA series too.
Yes I'm going to check that out too. Thank you :)
Just earned yourself a new subscriber. Well done!
Many thanks Cadell! Make sure you check out the other videos too.
Thank You for these videos. Will recommend to my colleagues!
Thanks John - please do spread the word!
Thank you for teaching is super easy to understand!
It's a pleasure and welcome to the channel! See you in another video series ...
Damn. Who would dislike these videos... Great content
Jimmy - one thing you can guarantee is that somebody will always 'dislike'. I'm happy for the engagement though. Keep enjoying the videos!
Hello Tiger, Is there a book for VBA codes? I am a new beginner to VBA and I really don't know how to go about the codes. Thank you.
Hi David - I have never used a book but I know there are plenty on the market. I could not recommend a particular one though. I would say that if you work through our VBA for beginners playlist you will have an excellent foundation. Good luck!
Thank you very much. Very useful and interesting. So grateful for what you did.
Navarat Sompungthong You're very welcome, good luck with the code!
Thank you very much for these videos, really they are very helpful
Thanks Abdel - please do share them if they are helpful. Good luck!
Wow, these 4 videos were amazing to me. Thank you very much
Thank you and a big welcome to the channel!
Thank you for this wonderful presentation!
It's a pleasure Ritchie - do check out the other videos on the channel
Thank you! Very clear and great techniques of teaching! Thank you!
It's a pleasure Jimmy and thanks for watching!
Love, love your teaching style.
Many thanks Carla - do check out the other videos on the channel!
Great Trainer's, hope Sir you can contribute more for us to learns, thanks so much....smiles
Thank you and welcome to the channel - please check out the other videos too ...
Thanks Tiger! even my English is not good, but i can catch up your lesson, thanks a lot!
It's a pleasure - good job!
Excellent explanation. Very didactic and professional.
Thank you and please check out the other videos on the channel.
These videos are so helpful for basic understanding of VBA, kindly make a video for next step.
Shubham - many more videos on the channel. Check out our Excel VBA for Beginners playlist.
Very well explained, thanks.
Thank you - please spread the work about the videos :-)
Sir very well explained, thanks a lot.
Thanks Sushil - good luck with your coding and please check out the other videos on the channel.
excellent this is the true coaching method... thanks a lot
Many thanks Ravi and welcome to the channel
Easy peasy! Now, how would you go about a Loop to go from zero (0 = initial position) to n-th position based MsgBox, InputBox, another Loop? Thank you for your time and assistance!
Hi there - it's an extension of what we do here. Check out our 30 for 30 Excel Absolute Beginner course for the required skills / techniques.
Great videos, was able to play around with the coding and do different things within minutes. Trying to expand my skill set so this a great start ! Nice and short videos too :)
Great to hear - do check out the other videos on the channel!
It's 2k19 and your vids are still useful :)
Thanks Surya - I'm still making them in 2019, do check them out!
Thank you s much for just making this simple! very clear explanations!
You're very welcome - please do share the video with somebody whom you think it might help :-)
All I need is the basics to Understand the coding; for eg. you have used Dim, Show, Unload etc.
I want to understand this concept, which will make me write codings in future easily..
Do you have any such video explaining the coding language.
Thanks in Advance.
Really appreciate your videos, hats off to you for your way of educating people...
Cheers....
Hi Mohammed - you can see all of my videos on this channel. Most of them are practical (not theoretical) in focus, but I think that really is the best way to learn coding.
Good luck!
I Totally agree with Alison D comments Below I have been doing it all wrong I've learned so much from your video going along with everything you did on the excel spreadsheet went fine and I learned so much can you Help Me A little problem I have How can I write a simple VBA When I click on a box it will enter a 3 digits number then when I click on it again it will Move Down to the next cell to repeat the same process Hope you can help. Thanks :-)
Thank you so much . You teach very clear and helpful.
Thanks Sayed and good luck with your coding.
Hi, you made that look so easy, I'd like to learn more to help me at work, working with excel for the first time
Thanks Bob - check out our Excel VBA for Beginners playlist
simple and straight to the core...crystal clear explanation. thank you so much. i sub you and expecting more valuable lessons from you. respect
Many thanks Indu - good luck with you coding
very well explained, thank you so much for sharing !!
Thanks Umesh and good luck with your coding.
Well done!
Very good introduction to VBA Programming all love your channel. Nevertheless, for those who are more book learners, which book on VBA programming do you suggest? In my case, I have financial / investment / business intelligence applications in mind (financial projections, financial statement modeling, simple portfolio analysis, stock screeners etc).
Hi Benjamin - thank you and welcome. I did purchase Excel VBA for Dummies back in the day which I got some value out of.
Hi Tiger, fantastic video!! Loved it and the rendering. Please do publish more of these.
Thank you for watching - there are plenty more videos on the Tiger channel, and we release at least 1 per week, see you there!
Very thorough and informative!
Many thanks Joe and welcome to the channel!
Hi Tiger your beginners series is awesome and its very crystal clear. Could you please make some more vedios using big excel data sheets
Hi Shoaib - thank you, the other video series are more complex, I hope you'll enjoy them
You are great at explaining. Thanks.
Many thanks Halimat and good luck with your coding :-)
You've got my subscription coz you're a great teacher. I will much from you
I appreciate it my friend, welcome to the community and see you in another video!
I feel empowered thanks Tiger
Good to hear - please do share the videos with somebody else
Your videos are brilliant, many thanks!
The best tutorial for beginners...
Thank you!
Thank you sir for clear explanation and wants to make a complete course of Visual basic ,
It's a pleasure and welcome to the channel ...