Want to learn VBA? Here is a simple but in-depth tutorial (you will make 2 useful apps by end)

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.

Видео Want to learn VBA? Here is a simple but in-depth tutorial (you will make 2 useful apps by end) канала Chandoo