Take your Excel VBA skills to next level with these 3 Examples

Video Description

This is a continuation of our "getting started with VBA" tutorial - https://youtu.be/5k-KpSkrROw In this "Next level" Excel VBA Programming tutorial, you will learn how to create three powerful macros: 1) Adding "Check my cell" macro as a button to ribbon 2) Making a better To do list with Double click event 3) Using Auto filter to extract data from a table 🛑 ~IMPORTANT~ 🛑 ================== Watch Part 1 of this video (or recap) here - https://youtu.be/5k-KpSkrROw In this tutorial, you will also learn VBA / Macro coding skills such as, 👉 How to enable and use Personal Macro workbook 👉 How to add macros to ribbon / QAT 👉 What are application events, how to add them 👉 Dealing with events, customizing the code 👉 Working with auto filter in VBA macros 👉 Showing a message with msgbox function 👉 How to learn and take your VBA skills forward Video Timestamps ⏱👉 ==================== 0:00 - Introduction and what we are covering? 1:00 - Adding "CheckThisCell" macro button to ribbon 4:28 - Enhanced ToDo List Macro 4:50 - VBA concepts - Macro vs. Function vs. Event 6:00 - Adding DoubleClick event & customizing the code 11:07 - Data Extractor with Auto Filter 13:45 - How to learn VBA - 4 step plan Sample File 📗👉 ============== Download the sample file from below link. Go to "View code" to see the various code modules. It has the code from "Getting started" tutorial too. https://files.chandoo.org/vba/more-vba.xlsm Resources to learn VBA 📚💻💡 ========================== 1️⃣Recommended Books: Excel VBA Programming for Dummies - https://amzn.to/3Ezf5B3 Excel Power Programming - https://amzn.to/3lLe2Ft 2️⃣Recommended articles & pages: Excel VBA - A guide: https://chandoo.org/wp/excel-vba/ 3️⃣Recommended Course: VBA Classes by Chandoo - https://chandoo.org/wp/vba-classes/ Wish you all the best in your automation journey. Have a beautiful day. Note: I am using my affiliate link for the books. You can support me by purchasing the books from that link. #VBA #Macros