Hello everybody,

I have a simple calendar on form. I would like my program to perform some action as I change the dates on the calendar, for instance assign the value of that specific date that I click to a "txtBoxA" which is on the same form. How would I do this.

The calendar data property says:

Control Source _______________
OLE Class Calendar
Class MSCAL.Calendar.7

Thank you very much.

In the calendar's OnChange event, set the textbox to be equal to the calendar.

The Calendar's events are:
OnUpdated
OnEnter
OnExit
On Got Focus
On Lost Focus

So, OnChange is not there. Anyways, I tried doing that already with all the above events including "On Updated" and when clicking on the dates it doesn't do anything.

Thanks

Can anyone please give me a hand with this problem?

Thank you very much.

Although the on click event for the calendar is not visible in the property list it will still work in the VBA code
try this

Private Sub MyCal_click()
'Clicking the Calendar Buttons calls this Code.
'Your Code goes here
End Sub

The name of the calendar in this example is called MyCal
Garry

It works now.
Thank you very much for your help