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.

Комментарии

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