Creating userform to input an event on a calendar, the hours spent, and have it color coded

[JennV]

Hello there,

I'm hoping to get some advice and guidance on how to start.

I used an Excel calendar template, which was perfect because it has a select year option to display all 12 months of the year, then I listed out some dates for events A, B, C to conditionally format it on the calendar (different color per event) but I don't know how to associate hours/display those hours onto the calendar. I thought about adding rows but since it's an Excel calendar template, it won't let me.

Ideally, a form can pop up so the user can input the event (A, B, C), the date, and the hours.

Thanks in advance!