Calendar (Excel Function or VBA)
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
|