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/livede...
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