Learn how to develop VBA code to solve practical problems in this Masterclass. Code samples will be provided.
📁 Sample file (from the stream): [ Ссылка ]
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
