DISCLAIMER: I cannot post my sheet/code to the site but all the help I can get is appreciated.

I have created a Userform so that when a person's name is double clicked (in column A), the form pops up. The form includes a combo box to choose an event, a combo box for the each the start month, day, and year, as well as a combo box for each the end month, day, and year. There is also a comments section included (which will not be shown in the calendar but I do need some way for it to be seen). I have been trying to figure out how to save the start date-end date so it shows up as a block of one color on the calendar (each event would be a different color) for that person that was clicked. I would need to be able to block off more than one date range for the different events they may be attending for the year. I have been having trouble figuring out a way to use the month/day/year entered in the form to translate to the calendar I have created. The calendar is a simple cell by cell on the top of the sheet with each day of each month laid out so should I create a different type calendar that is more compatible to the Userform or can I tailor the Userform to that calendar. Any and all help is appreciated. Thanks.