DatePicker (Eyre) selectdate causing Runtime error 13 if text box empty

Hello,
I'm very new to VBA. I've searched datepicker threads and found no answer for my problem.

I have several date fields in a user form, which for example DOB can be 80-90 years ago. The Eyre date picker is working fine in it's most basic form without options. If a user wants to change the date, the date picker is defaulting to the current month and year which for DOB is frustrating for users as you need to scroll through up to 90 years. The code below works fine if there is data in the text box ie datepicker starts at the date already in the text box, but when the text box is empty (new data entry) it causes a runtime error 13 (data type mismatch).


Private Sub imgDateDeath_Click()
Dim myDate As Date

myDate = CalendarForm.GetDate '(SelectedDate:=txtDateDeath.Value)

If myDate > 0 Then
txtDateDeath.Value = Format(myDate, "dd/mm/yyyy")
End If

End Sub


Any advice is gratefully received.

What is Private Sub imgDateDeath_Click() if you are putting result in a textbox ???????
If you are stuck attached another option - this has combo to take you back & forward - the range can be altered in the code.
The demo fires on the double-click in columns A & B - you can alter the code to trigger in your textboxes.

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thanks.
Here is a sample file.



myDate = CalendarForm.GetDate(SelectedDate:=txtDateDeath.Value)

works fine if you search for existing client with data, but not when form is reset and field is empty. I can't have default values because the people entering the data wont actually change it.

Thanks again

I used the 'Eyre' calendar in an app submitted on this site some time back.
I found i had to transfer to the main form the code element relevant to the calendar type.
I only used the double click to call the calendar, you are using two call methods are they conflicting.
Look through the attached app it may provide a guide as to the handling of the calendar.
torachan.