In the UserForm_Initialize Event, where ctlCalendar is the control's
name.

Me!ctlCalendar = Date

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

I have a MS Calendar Control (DTPicker) in an User Form. How do I modify the properties (value property) from a past date that somehow got in there to a variable that displays current date. I have tried Today and Now but keep getting error msgs when I try to change the "value" property. Thanks