@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)

@fokhrulislam2633

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."

@josephdaquila2479

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.

@researchmind6792

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

@avantikaraj210

Thank you so much sir,:face-red-heart-shape: you always teach something we can use in our  work

@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 😊

@Whoispritam

Thanks for sharing valuable knowledge

@madhurig3974

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

@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.

@fokhrulislam2633

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

@lokeshagarwal6373

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

@MAH8897

Hi Chandoo,

My best Birthday wishes and lots of love to your lovely kids.πŸŽ‰πŸŽ‰πŸŽ‰

Have great 🎊celebrationπŸ₯³

From Hyderabad.

@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

@PRAKASHKUMAR-nl3bf

Hello Sir, I am watching this video from Noida. I am working as a MIS executive.

@cedricmbelesaylove8153

Watching from Dr Congo in central Africa

@gospelmoto2833

Another WOW project of yours Chandoo! Many thanks!

@MehediHasan-hk9mk

Flying the crow Chandoo is my bro. πŸ˜‚β€β€β€ Love from Bangladesh.

@josephw9690

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

@sivaprakasam6550

I saw your lot of videos and so your website, very interesting and awesome. Mainly dashboard example very well and learning from this. . .πŸŽ‰ πŸŽ‰ πŸŽ‰

@YeshodhaBiradar

Hlo sir,I am watching this video from Koroor.I am studying as a course data analyst