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
0 Comments