Learn VBA & Excel Macros in 20 minutes - with code samples 👨‍💻

Описание к видео Learn VBA & Excel Macros in 20 minutes - with code samples 👨‍💻

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 -    • Take your Excel VBA skills to next le...  


SAMPLE FILE 👉
==============
https://files.chandoo.org/vba/getting...
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?l...
Online VBA Class for more - https://chandoo.org/wp/vba-classes/

Playlists & Videos 📃🎥
====================

My VBA examples playlist -    • Excel VBA Examples & Projects  
Introduction to conditional formatting video -    • Introduction to Conditional Formattin...  

Got Questions 🤷‍♂️❓
=================
Post a comment so I can guide you.

* The amazon shop link uses my affiliate code.

Комментарии

Информация по комментариям в разработке