Excel VBA Macros - Beginner to PRO Masterclass with Code Samples @chandoo_
Excel VBA Macros - Beginner to PRO Masterclass with Code Samples  @chandoo_
Uploaded September 2023 | Updated November 2026, 3 hours ago
Learn how to develop VBA code to solve practical problems in this Masterclass. Code samples will be provided.

πŸ“ Sample file (from the stream): files.chandoo.org/vba/live-demo.xlsm


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

debug.print("Like and share this video. Thank you πŸ™")

end sub
Excel VBA Macros - Beginner to PRO Masterclass with Code SamplesMake an AWESOME Employee Dashboard with Power BI (Adv. DAX)Second Week Sales Only with SUMIFS (Excel formula)Filled Column Charts in Excel - Amazing Dataviz TrickGet ALL Option in Excel Data Validation with this Crazy Trick πŸ’‘This Excel Fuzzy Match Formula is CRAZY GOOD 🀩5 HR KPIs Every Analyst Needs to Master #HRAnalytics #KPIsThis Excel Trick shows the New Customers Quickly!Excel Formula to Show Top Sellers InstantlyPower Query - Advanced Tips + Q&A - REPLAYAdvanced SQL for Data Analysis - 10 Powerful Examples in 40 minutes πŸ•—How many days overlap between two projects [Excel Formula Magic]
Chandoo |

Excel VBA Macros - Beginner to PRO Masterclass with Code Samples

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER