Перейти к содержимому

Giving Excel a $10,000 Software Glow Up

VBA by MBA

0:00 / 0:00

Giving Excel a $10,000 Software Glow Up

239 просмотров · 4 месяца назад
VBA by MBA
437 подписчиков
239 просмотров · 4 месяца назад
🚀 Hard time doing it? Let's collaborate! Hire me directly on Fiverr for safe delivery: 👉 https://www.fiverr.com/s/0b79V3L 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. 🕒 Timeline 00:00 – Introduction: Upgrading our Custom Excel UI 00:18 – Reviewing the Project Milestones & To-Do Dashboard 00:32 – Fixing Keyboard Navigation & Disabling TabStop for Checkboxes 01:16 – Streamlining User Workflow for Data Input Fields 01:48 – Identifying Static UI Elements (The Cancel Button) 02:09 – Code Shortcut: Importing Pre-Built Calendar Controls & Assets 02:28 – Fine-Tuning UI Layout, Icon Positioning & Testing the Form 02:52 – Writing VBA Code for Button MouseMove Hover Effects 03:38 – Updating Hex Codes for Immediate Visual Warnings 04:07 – Ultimate Test & Previewing Next Video’s Validation Logic Challenge