Everyone has a calendar variant. This is mine.
Calendar Variant
-
-
-
Re: Calendar Variant
Hi Fengore,
I have use your workbook on 8 May 2006. However, when I opened the calendar, it shows August 5, 2006. I believe this may have something to do with my regional settings as I use the format "dd mmm yyyy". I like your calendar control, but how can I go about the day and month issue?
-
Re: Calendar Variant
Try this. Just click the blue display box at the bottom to toggle between the two formats.
-
Re: Calendar Variant
Hi Fengore,
Thanks for getting back. The revised calendar still cannot work on my system. However, when I changed some lines of your code, everything works fine. The changes are as follows:
In the UserForm_Initialize Event:
In the DetermineCalVariables procedure:
CodeFirstDayOfMonth = CDate("1" & "/" & Month(CurrentTargetDate) & "/" & Year(CurrentTargetDate)) c = CDate("1" & "/" & Month(FirstDayOfMonth + 45) & "/" & Year(FirstDayOfMonth + 45))
It seems that when I use date sequence [Day, Month, Year] instead of [Month, Day, Year], the code will work. Although I could not understand why I have to change the date sequence in order to get it working, but that's what I have to do to make it work.
I hope my solution will help others with the same problem.
Thanks again, Fengore, for your great calendar. It rocks!!
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!