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

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

244.377 Lượt nghe
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 - 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.