Tag: Excel VBA

Excel VBA UDF Optimization: Using Dictionary Caching for Speed

Posted on December 6, 2025December 7, 2025 by raymond Posted in Excel/VBA, Microsoft AccessTagged Access database integration, eliminate VLOOKUP, Excel Automation, Excel best practices, Excel caching, Excel caching techniques, Excel database lookup, Excel developer tools, Excel front end Access backend, Excel optimization tips, Excel performance optimization, Excel UDF performance, Excel VBA, fast Excel formulas, reduce Excel file size, speed up Excel UDFs, VBA dictionary, VBA dictionary caching, VBA UDF optimizationLeave a Comment

When a UDF looks up data from an Access table, Excel can end up calling the function hundreds or even thousands of times during recalculation. Without a cache, each call hits the database (a.k.a. server trips), opening connections, running queries, and slowing things down unnecessarily. By loading the product table into a VBA Dictionary the […]

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 […]