Author: raymond

Dynamic Gantt Charts

Posted on March 27, 2025August 21, 2025 by raymond Posted in Excel/VBATagged advanced excel Gannt Charts, Dynamic Gannt Charts, Dynamic Gantt Chart, Event Handling VBA, Excel, Excel Automation, Excel Bar Chart, Excel for Business, Excel Formulas, Excel Free Download, Excel Project Management, Excel Project Planning, Excel Project Tracker, Excel Tips, Excel Tutorial, Excel VBA, Excel VBA for Projects, Excel VBA Shapes, Free VBA Resources, Gantt Chart, Gantt Chart Example, Gantt Chart Excel, Gantt Chart VBA, Project Management, VBA, VBA Code, VBA for Beginners, VBA for Project Management, VBA Gantt Charts, VBA Programming, VBA Shapes, VBA Shapes for Gantt Chart, VBA TutorialLeave a Comment

Dynamic Gantt Charts In this video, I demonstrate how to create a dynamic Gantt Chart in Excel using VBA, including annotated “Event” diamonds to highlight key moments, like delays due to vandalism or bad weather. You’ll learn how to: Use VBA to create and add shapes (rectangles and diamonds) for chart visualization. Add event-specific code […]

Excel Auto Backup Tool (Free)

Posted on March 23, 2025April 3, 2025 by raymond Posted in Excel/VBA, UncategorizedTagged Auto Backup Excel Files, Backup Excel Files Automatically, Backup Excel Files to Zip, Backup Tool for Excel, Excel Auto Backup, Excel Backup Tool, Excel File Backup Software, Excel File Safety, Excel File Versioning, Excel Version Control, Excel Version History, Excel Zip Backup, Secure Excel BackupLeave a Comment

In today’s fast-paced, data-driven world, businesses of all sizes rely on spreadsheets for everything from daily tasks to business-critical operations. However, despite their importance, many overlook the risk of losing these invaluable files due to corruption or human error. That’s where the Free Excel Backup Tool comes in. This tool is designed to protect your […]

Excel Calendar Add-in Tool (Free)

Posted on November 16, 2024April 3, 2025 by raymond Posted in Automation, Excel/VBA, Freelance MS Office Developer (VBA)Tagged Automated Excel Calendar, Business Calendar Tool, Cost-Effective Calendar Solution, Custom Excel Calendar, Custom Excel Planner, Custom Excel Tools, Custom Scheduling Calendar, Excel Calendar Automation, Excel Calendar Data Reporting, Excel Calendar Design & Branding, Excel Calendar for Business, Excel Calendar for Construction, Excel Calendar for Healthcare, Excel Calendar for Retail, Excel Calendar for Staff Scheduling, Excel Calendar Forecasting, Excel Calendar Integration, Excel Calendar Software, Excel Calendar with VBA, Excel Event Planning Calendar, Excel Scheduling Tool, Excel Task Management Calendar, Excel Workflow Calendar, Industry-Specific Excel Calendar, Project Management Calendar, Resource Management Excel Calendar, Tailored Excel CalendarLeave a Comment

https://youtu.be/lxR1HnjfQqQ Unlock the Power of Customization with My Excel Calendar Add-In! Welcome to my website, I’m showcasing my custom-built Excel Calendar add-in that’s designed to give you full control over your calendar’s appearance and functionality. Whether you need to mark specific days off, adjust the start of your week, or display up to four months […]

Build a Smart Excel Combobox

Posted on February 27, 2021 by raymond Posted in Excel/VBATagged combobox in excel, combobox in vba, excel combobox, excel machine learning, machine learning, machine learning in excel

Like most things in life, Excel VBA users mature as they write code overtime. Every time we search the internet for a vexing VBA problem we learn something. Of course, I hope you take the time to look at more than one solution because there may others that are better or more appropriate. In this […]