VBA - Macros for Word & Excel

14/08/2026

08/08/2026

06/07/2026

Fixing a client's broken Excel VBA macro live on Zoom! In this uncut and raw session, we debug a common but frustrating "Runtime Error 9: Subscript out of range" that completely stopped production. Watch the step-by-step troubleshooting process as we isolate the problem, look at the code ex*****on, and figure out how file paths and environmental constraints (like desktop limitations and OneDrive syncing) impact script ex*****on.

Whether you are learning how to automate workflows or debugging tricky Visual Basic for Applications scripts for your own clients, this live troubleshooting workflow shows exactly how to dissect an issue and find the solution in real time.

⏱️ Timestamps
0:00 – Client shares the broken system

0:22 – Replicating the "Runtime Error 9" crash

0:40 – Investigating file path configurations

2:20 – Debugging the specific line of code

2:55 – Isolating the C: drive directory fix

4:10 – Testing the system behavior in SharePoint

4:40 – Solution confirmed & recap

04/07/2026

Stop wasting hours clicking through endless nested folders! 📂❌ In this video, I show you how I built a custom ToDo List Manager application to completely fix file clutter for freelancers and developers.

Key Features Shown:

Automated Organization: Instantly sorts project directories cleanly by Year and Month.

One-Click Live Preview: Instantly see a live preview of dashboards, charts, and files without opening them.

Dynamic Status Tracking: Update progress flags (Estimation, In Progress, Complete) on the fly.

Instant Access: Double-click a row to pop open the folder in Windows File Explorer instantly.

Stay tuned for v2.0 updates featuring a refreshed UI, direct folder renaming, and a smart subtask progress system!

If you love custom productivity tools and development tutorials, hit that Like button and Subscribe for more! 🏆👇

03/07/2026

https://youtu.be/KUB9IKz7H6Q

Managing dozens of client project folders manually is a massive waste of time. Every single day, I found myself digging through layers of directories, backtracking, and losing track of active tasks. So, I built a custom, standalone desktop application to fix it forever!

In this video, I demonstrate my new custom To-Do List Manager and File Previewer. It instantly indexes client directories by year and month, lets me preview dashboards and charts with a single click, and opens the exact folder with a double-click. No more messy File Explorer. No more wasted time.

Watch until the end to see the upcoming features, including a smart sub-task checklist with real-time progress calculations!

If you're looking to upgrade your developer workflow or love custom productivity tools, don't forget to LIKE and SUBSCRIBE for more updates!

Video Breakdown & Key Features
0:00 – 0:28 | The Problem
An introduction highlighting the frustration of digging through endless nested folders and wasting time navigating File Explorer to find client work.

0:29 – 0:40 | Introducing the Solution
Presenting the custom ToDo List Manager - v1.0 interface designed to keep all projects organized in one standalone view.

0:41 – 0:46 | Setting the Directory
Demonstrating how easy it is to use the Browse button to select your primary projects root folder (C:\Projects).

0:47 – 0:58 | Automated Organization
Showing how the application instantly reads the directory and sorts folders cleanly by Year and Month.

0:59 – 1:13 | One-Click Live Preview
Showcasing the live preview feature where selecting a client folder dynamically loads an image preview of the active spreadsheet, dashboard, or chart on the right panel.

1:14 – 1:35 | Dynamic Status Tracking
Demonstrating how to change project status flags (Estimation, In Progress, Complete) directly through radio buttons, which instantly updates and dynamically re-orders the list view.

1:36 – 1:49 | Instant Folder Access
Showing the efficiency of double-clicking a client row to instantly open the physical folder directory directly in Windows File Explorer.

1:50 – 2:21 | Future Updates Roadmap
Outlining upcoming plans for the next version, including:

A refreshed UI layout.
Direct folder renaming.
On-the-fly client folder creation.

A smart subtask checklist system with automatic completion percentage tracking.

23/06/2026

A massive client gave me exactly 24 hours to build a fully custom, bulletproof automation system, or they walk away forever. But there’s a catch: they need a dynamic, perfectly synchronized user interface that doesn't even exist in standard software—and if my math or alignment is off by even a single pixel, the whole system crashes. Watch how I tackle complex dynamic menus, custom scrolling algorithms, and memory management to save the project before the clock runs out!

21/06/2026

Stop Making Ugly Excel Forms! Upgrade Your VBA UI & UX Design Today

What is up, automation family! Welcome back to the channel. Today, we are giving our custom Excel UserForm UI a massive, professional upgrade. If you think Excel is just rows and columns, think again—we’re about to completely change your mind.

In this tutorial, we focus on refining user experience (UX) and interface design (UI) in VBA. We’ll show you how to fix broken tab orders to improve workflow efficiency, import a custom calendar date picker, align layout lines, and create sleek mouse-move hover effects for your buttons using custom color hex codes. Stick around until the end where we hit a snag with our submission validation logic—our next video will cover diagnosing and fixing that entirely from scratch!

If you're ready to unlock professional Excel dashboards, make sure to hit that subscribe button, smash the like, and drop a comment below.

16/06/2026

https://youtu.be/Vix4kcVqajM

Have you ever built an Excel macro that works perfectly on your com...

14/06/2026

Create 1,000,000 Million Slides in ONE Click! 😲
https://youtu.be/niKJomy8Dfk