Btw: This are events of the control

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" wrote in message ...
You can use this maybe

Private Sub Calendar1_NewMonth()
End Sub

Private Sub Calendar1_NewYear()
End Sub

See also
http://www.rondebruin.nl/calendar.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"ll" wrote in message oups.com...
Thanks,

I am really looking for a way to make the calendar only "need" the
month and year - without having to manually click on the day in order
to fire the script. I've tried doing an "on change" so that when the
month was changed, the date would automatically be placed in a box on
the form, but that didn't work.

I am trying to put the calendar into the form itself, rather than
having it on a secondary form. I have hidden the days, as they are not
needed. I have one submit button that submits a course name, category,
and (hopefully) the date to a spreadsheet from this form. The problem
is, the date will not populate the spreadsheet without having a click
event from the days - I wonder if my only option is to set up another
"OK" button next to the calendar selection in order to fire the date?

Thanks again