Excel VBA - Beginner to PRO Masterclass with Code Samples

Learn how to develop VBA code to solve practical problems in this Masterclass. Code samples will be provided.

Timestamps:
===========
0:00 - Welcome message & hellos (skip this if you want)
12:00 - What is covered in this video (VBA intro, practical example, VBA vs. Python vs. Office Scripts)
16:20 - Introduction to VBA - What is it and when / where to use it?
26:54 - Using "Macro Recorder" and creating your first VBA macro - simple example
33:50 - Understanding the recorded macro
37:52 - Customizing the recorded macro by adding your own code
39:45 - Adding a button to run the macro
41:40 - Adding the macro to Excel ribbon
50:04 - ChatGPT and VBA... my thoughts
53:06 - VBA Object model - explained
57:55 - Creating a simple "TO DO List" App with VBA
1:12:40 - IF condition in VBA
1:15:03 - Adding time stamp (with variables in VBA)
1:20:35 - Showing a message with msgbox()
1:32:38 - Highlighting done activities (with conditional formatting)
1:33:46 - Python vs. Excel
1:39:30 - Highlighting done activities (with VBA)
1:42:30 - Writing a loop in VBA (For Each)
1:51:00 - Discussion about VBA vs. other technologies, Q&A and random musings (watch if you have time)

#vba #excel

~

sub LikeAndShare()

end sub

[chandoo_]

Skip to 26:00 for the content. First 25 minutes is hellos, intros & theory. Use below timestamps to skip to specific sections. Happy coding :)

⏱ timestamps:


0:00 - Welcome message & hellos (skip this if you want)
12:00 - What is covered in this video (VBA intro, practical example, VBA vs. Python vs. Office Scripts)
16:20 - Introduction to VBA - What is it and when / where to use it?
26:54 - Using "Macro Recorder" and creating your first VBA macro - simple example
33:50 - Understanding the recorded macro
37:52 - Customizing the recorded macro by adding your own code
39:45 - Adding a button to run the macro
41:40 - Adding the macro to Excel ribbon
50:04 - ChatGPT and VBA... my thoughts
53:06 - VBA Object model - explained
57:55 - Creating a simple "TO DO List" App with VBA
1:12:40 - IF condition in VBA
1:15:03 - Adding time stamp (with variables in VBA)
1:20:35 - Showing a message with msgbox()
1:32:38 - Highlighting done activities (with conditional formatting)
1:33:46 - Python vs. Excel
1:39:30 - Highlighting done activities (with VBA)
1:42:30 - Writing a loop in VBA (For Each)
1:51:00 - Discussion about VBA vs. other technologies, Q&A and random musings (watch if you have time)

[fokhrulislam]

I am not a programmer. Once I asked for help from a programmer to scrape and sort some data from a website. He did that for me. Fun fact is that his code took more time than my template (Excel+Some Formula+1 VBA). Just sharing my experience. Like Chandoo said "You will know when you need to use Excel or Python. Consider both just as tools."

[researchmind]

Awesome passion for you as a youth skilling leader. In this era, you're my mastery of tech areas.

[gospelmoto]

Another WOW project of yours Chandoo! Many thanks!

[madhurig]

Thank you so much for this VBA videoand also for sharing knowledge on scope and possibilities with VBA and Excel!

[josephdaquila]

I think the nice thing about VBA is that the better you get Excel the better you get at VBA. Knowing that the built in Excel functions seems to lead to seeing more opportunities to use those as opposed to writing code to accomplish the same thing.

[RobertAfrick]

Thank you, Chandoo, for all you do! Your videos are awesome. Your style is unique--it draws you into the conversation. You uniquely take topics that can be, well, boring, and create excitement. Your explanations are simple to follow and provide actionable advice for all to use in their daily job.

[fokhrulislam]

Thank you for your contribution helping and educating us in many ways.

[josephw]

Thanks, great lecture!
Definitely wanna see a video about utilizing GPT for VBA coding! Also how to build “repetitive” Pivot Tables via VBA

[subramanianvelusamy]

Thanks chandoo for sharing your knowledge for all of us

[cxHxIa]

Thank you Chandoo - I learnt Power BI from your tutorials and now VBA - you explanation is so clear.. and I don't go to any training videos - and also you fellow Telugite Baaga Explain Chestaru..!😀 Pawan

[MAH]

Hi Chandoo,

My best Birthday wishes and lots of love to your lovely kids.🎉🎉🎉

Have great 🎊celebration🥳

From Hyderabad.

[lokeshagarwal]

Happy Birthday to your children... they have got amazing

[jerrymiles]

Hi dear Chandoo, best regards from Limón, Costa Rica!

[cedricmbelesaylove]

Watching from Dr Congo in central Africa

[MehediHasan-hkmk]

Flying the crow Chandoo is my bro. 😂❤❤❤ Love from Bangladesh.

[MindbodySync]

Dear Chandoo, Seen your several videos and by far i can say that your videos are very informative and i just loved them, Not to forget i like them as well, if not all -Most of them.. However this live session does not do justice to the time spent. I was really wishing if could really learn being a beginner.
Nevertheless proud of the work you are doing and honoured to be part of this channel 😊

[venkatakameswararaomukkama]

My best wishes to your family and dear Poorna Chandu....

[cloudy]

I'm drinking coffee now while watching

[boubekeurzeffane]

Thanks for sharing, I follow you from ALGERIA