Altering DatePicker to write to Textbox on userform

Hello All!

So this time I'm looking to alter already existing code (and I'll admit there is so much in the calendar module I thought looking to you would help keep my sanity).

First, I have a userform I am going to have write to the sheet based on currentregion (this bit I am pretty certain I can achieve already with previous code I've used). But there are about 14ish textboxes in the userform that require a date.

Rather than deal with the end user always entering the proper format, I went the way of a date picker. I found a calendar form and code online and incorporated it into my workbook.

The short of it:

1. I have already established that every time a user clicks one of the date textboxes, the datepicker opens up.

2. Hitting okay on the datepicker writes the date 12/30/1899 into the textbox, which from reading the notes in the code, is the date written when there is an error.

3. The date is written to a cell in the sheet in addition to the date in the textbox.


What I'd like to do if possible:

1. Have the date picker open exactly as it does now, when the textbox is clicked.

2. Have the date selected write only to the textbox once the okay button is hit.

3. (Optional) If the textbox already contains a date, have that date be selected as the datepicker opens.

See attached file for work so far.

Thank you all in advance,

-LM

Hi Everyone,

I contacted the original creator of the calendar and he replied in very short order with a solution. I'm attaching the testfile he sent me (and his original calendar) that illustrate the difference between what I had and what I ended up with.

Thanks,