VBA: Calendar with event dates labelled with color and hours listed per day

[JennV]

Hello there,

I'm hoping to get some advice and guidance. I'm trying to create a calendar color coded by the event type and the number of hours spent per day.

To start, I used an Excel calendar template (it's the most applicable to my situation as it allows users to flip through years and display months for that year) and then applied conditional formatting to gray out weekends. Next, since the events each have a set amount of days, I applied conditional formatting per event. For example, event A is 4 days log, so from a start date to an end date, it's fill in as yellow on the calendar.


The struggle is, since it's a calendar template, it won't let me add rows. In addition, I'm not sure how I'd be able to have users add hours per day. Perhaps by using a userform through VBA?

January 2019
[TABLE="width: 500"]
<tbody>[TR]
[TD]Sun[/TD]
[TD]Mon[/TD]
[TD]Tues[/TD]
[TD]Wed[/TD]
[TD]Thurs[/TD]
[TD]Fri[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]8.5[/TD]
[TD]8.5[/TD]
[TD]5.5[/TD]
[TD]5.5[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]8.5[/TD]
[TD]8.5[/TD]
[TD]8.5[/TD]
[TD]etc.[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]12[/TD]
[TD]13[/TD]
[TD]14[/TD]
[TD]15[/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thank you in advance!