Tag: Excel

Dynamic Gantt Charts

Posted on March 27, 2025March 28, 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 […]

Fixing other Developers Work – Avoiding Needless Complexity

Posted on December 18, 2022 by raymond Posted in Freelance MS Office Developer (VBA)Tagged Craftsmanship, Excel, Freelance VBA Developer, VBA

Craftmanship to aspire to One of my best customers called and asked me if I could fix an app. I knew and was friendly with the original developer. I had helped him with some code several times on zoom. He was new to MS Office development. While I’m always happy to help, fixing other people’s […]