I echo si_the_geek's comments. Thanks for sharing.

The leap year testing could also be optimized a bit by using the DateSerial function
vb Code:
  1. Private Function IsThisALeapYear(ByVal intYear As Integer) As Boolean
  2.      IsThisALeapYear = (29 = Day(DateSerial(intYear, 2, 29)))
  3. End Function