Hi

Im pretty new in VBA, but have managed to create the Calender following the
information given in http://www.fontstuff.com/vba/vbatut07.htm (put in
private). Now i would like to use this calendar for editing a date in a form
(Deadline) when I doubleclick on the deadline field in the form. This issue
is that I can't figure out how to get the calendar to initially show the
value currently in the Deadline field and update the field with the date
selected in the calendar tool. Any help out there would be much appriciated.

Below a stup of the code to ligten up the Calendar Tool:

Private Sub txtDeadline_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
Cancel = True
'Call OpenCalendar
Application.Run "Personal.xls!OpenCalendar"
End Sub

/Stony