Hi everyone,

I'm trying to work on a side project, my idea is that I'm trying to keep everyone on the same page by using an interactive calendar.

Here is what I'm thinking:
- An input form that allows users to enter information, select certain categories of work it pertains to
- This information is then fed into a "heat sink" calendar that has different colored blocks that is placed on a Q1-Q4 calendar

An example:
Name: A
Project Name: B
Type of Work: C
Length of Time: Q1-Q4

So then this information would be placed on a quarter calendar that has a green block (as green is the color key for C) and it extends from Q1-Q4 on the excel calendar.

As of now, I am thinking of using VBA form combined with an actually excel document, however I am stuck as to how to approach it. I've been googling things for the past couple of days and I can't really find anything that can point me in the right direction. I have a tiny bit of C# coding skils so from a coding perspective, I can see how it might work.

Does anyone have any ideas as to a guide or maybe some resources I can check out to complete this project?