Date Picker on Excel UserForm (Solved)

[Oliver]

Hello all,
How can I add a date picker on excel UserForms? I thought this post was gonna help but didn't.
Thank you in advance!!

How I did it: Right-clicked on the tool box and ticked the "Microsoft Outlook Date Control" from the Additional Controls dialog (See Picture).

Date_Picker.PNG

[HansV]

Alternatively, you could use the calendar built from "native" userform controls found at Calendar Control for All Office versions - including Office 2016 64 bit (With Advanced Features).

[Oliver]

Hello Hans,
I am trying to use your suggestion from 2 years ago but I'm very confused on how I can add it to my userform. I tried pulling my old file but I couldn't find it.

[HansV]

The article explains how to use it:
- Import the cCalendar class module
- Add a Frame control to your userform
- Use code in the UserForm_Initialize event procedure to add the calendar to the frame

[Oliver]

I had to add “PtrSafe” to a few lines but is working great. Thank you Hans!