Calendar (Excel Function or VBA)

[Craig]

Hi there, I'm trying to created an editable calendar in excel. I have found
a few different methods for creating a calendar; one by using an excel
function array. I would like to create it in a userform. I need about five
boxes available for each date. This is used for entering holidays being
taken. So if I entered "Craig" under November 1, 2005 and I changed the
month to December, Craig wouldn't show anymore. But if I clicked the
calendar back to November I would see Craig under November 1st. I only need
to see one month at a time with a method for changing the month ahead or
back. I would also need to count the instances of "Craig" or another four
possible names for the year. So it would be a yearly Holiday
scheduling/tracking type of program.

What would be the best way to accomplish this? If it would be easier to do
via worksheet, it would be ok.

Thanks Craig

 

[Guest]

Craig,
I have copy of code posted by Tom Ogilvy which creates an
"events" calendar; in your case the events are holidays. If you are
interested in using this, send me a note and I will forward a workbook to
you. It is worksheet-based with one sheet per month; holidays are entered in
an "events" list and displayed in the cell of the given date.

([email protected])


HTH