VBA is a great entry-level programming language. If you have been looking for a solid, no-frills and practical guide to learn VBA, here it is.
In this detailed video,
* Learn what VBA is and how to find it in Excel?
* How to use recorder to record and replay Macros (steps or actions)
* How to write your own code using Visual Basic Editor (VBE)
* Making a simple to-do list app in Excel
* Creating a data extractor app in Excel
* How to self-learn VBA with recorder & help
Watch PART 2 here 2๏ธโฃ๐
====================
I just released a part of this video. Watch it here – https://youtu.be/nerIcLV7a2s
SAMPLE FILE ๐
==============
https://files.chandoo.org/vba/getting-started-with-vba-demo.xlsm
Companion article + resources – https://chandoo.org/wp/excel-vba/
Online VBA Class for more – https://chandoo.org/wp/vba-classes/
Timestamps โฑ
=============
0:00 Introduction
1:20 VBA in Excel – where to find it?
2:40 A simple macro – coloring cells
4:55 Recalling the macro (adding a button)
6:30 Modifying recorded macro code (VBE)
10:26 To-do list application with VBA
18:37 Data extractor app with VBA
22:39 How to learn more VBA
Resources to learn VBA ๐๐ป๐ก
==========================
Companion article + resources – https://chandoo.org/wp/excel-vba/
My recommended Excel + VBA books – https://www.amazon.com/shop/chandoo?listId=1EO2E2HMAFUSB
Online VBA Class for more – https://chandoo.org/wp/vba-classes/
Playlists & Videos ๐๐ฅ
====================
My VBA examples playlist – https://youtube.com/playlist?list=PLmejDGrsgFyCcACC_FRUFc03XYf1Mxf9k
Introduction to conditional formatting video – https://youtu.be/IUEHXzsgKVk
Got Questions ๐คทโโ๏ธโ
=================
Post a comment so I can guide you.
* The amazon shop link uses my affiliate code.
