Excel VBA Macros - Beginner to PRO Masterclass with Code Samples скачать в хорошем качестве

Excel VBA Macros - 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. 📁 Sample file (from the stream): https://files.chandoo.org/vba/live-de... 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