Use VBA to Build a Dynamic Gantt Chart with annotation diamonds

preview_player
Показать описание
In this video I demostrate using VBA to create an Excel Chart (Gannt) with annotation "Event" diamonds. Lesson from this demo are using VBA to create and add shapes. Adding event code to shapes. Using forms as Popup boxes...

You can see more interesting VBA Products and How Tos at my website
  1. VBA Craftsman
  2. Excel Charts
  3. Using vba to create charts
  4. Using VBA to add shapes in excel
  5. Creating shape events
  6. using Excel forms as popups boxes
Рекомендации по теме
Learn Excel VBA 0:14:02

Learn Excel VBA to Automate Anything

Excel VBA - 0:03:25

Excel VBA - Write a Simple Macro

Creating your first 0:00:35

Creating your first Button with Excel VBA

Excel Macros & 0:50:20

Excel Macros & VBA - Tutorial for Beginners

How to Create 0:10:09

How to Create & Use Excel Macros (Real world example)

Excel VBA - 0:05:28

Excel VBA - Create User Form

Excel VBA - 0:02:45

Excel VBA - Create Functions

How to Create 0:01:23

How to Create an Automated Data Entry User Form in Excel VBA

ChatGPT: Automating Excel 0:10:56

ChatGPT: Automating Excel with VBA like never before 🤯

Use VBA to 0:09:58

Use VBA to Build a Dynamic Gantt Chart with annotation diamonds

Excel VBA Explained 0:07:47

Excel VBA Explained for Beginners

How To Create 0:11:19

How To Create Vba Code Modules In Excel

How to Create 0:09:17

How to Create Macros in Excel Tutorial

How To Create 0:02:41

How To Create a Button to Run VBA Code

Learn VBA & 0:24:48

Learn VBA & Excel Macros in 20 minutes - with code samples 👨‍💻

5 Best VBA 0:00:56

5 Best VBA Practices | VBA to Excel | #shorts #vba #excel #automation

Assign a Macro/VBA 0:00:15

Assign a Macro/VBA code to a Button in Microsoft Excel

How to Declare 0:07:32

How to Declare (Dim) and Set VBA Variables (use data types correctly)

Create Userform in 0:18:42

Create Userform in Excel VBA Macro in Detail

Add Excel Add-in 0:00:26

Add Excel Add-in to your Workbooks to run VBA Macro with Custom Tab and Button

Excel VBA Beginner 2:10:31

Excel VBA Beginner Tutorial

Class Modules in 0:17:43

Class Modules in VBA: Made Super Simple

Vba Macro To 0:08:50

Vba Macro To Create Power Query Connections For Any Table In Excel!

Using VBA to 0:14:08

Using VBA to Enter Data into an Excel Table

Комментарии
Автор

Is there a link to this xlsm or the code used on your site? I've tried to find it, but there isn't anything on your site...

Porterhouse
Автор

Hi, great video. How would one add multiple annotation diamonds for the same project? When I do this and click on each diamond, it only provides one description (the topmost description). Also, how do you auto-update the red "today bar"?

nicholasallen
Автор

When I put in new dates for 2021, the columns for 2020 still exist. How do I have a project start date?

rthare