Excel VBA Beginner to PRO Masterclass with Code Samples
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=7hd1Nn4cNyI
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
#############################
