How to Add Date Picker To VBA UserForm

[NDMDRB]

Hello,

I have a userform and looking for a way to add a popup calendar to insert a date in a textbox,

I searched google and found the way below, I followed it step by step, but it didn't work,
https://chandoo.org/wp/pop-up-calendar-excel-vba/

Do you have any way to activate it?


I have windows 10 in my laptop 64 bit

 

[Fluff]

As it says in the article that only works on 32bit systems, the DatePicker is not available on 64bit systems.

 

[NoSparks]

Maybe check out https://trevoreyre.com/portfolio/excel-datepicker/ for a bit different approach.

 

[Fluff]

Or from Ron
http://www.rondebruin.nl/win/addins/datepicker.htm

 

[NDMDRB]

Thank you "NoSparks" & Fluff"

In this case, I already have a calendar form, but I'm not able to insert the selected date in the selected textbox

In my calendar form, in the Insert Button, I have the following code

Private Sub btOK_Click()
    dtSelectedDate = dtActiveDate
    ActiveCell.value = dtSelectedDate
    Unload Me
End Sub

This is what I use to insert date in a worksheet cells

Can you help me change this code to insert the selected date in the selected textbox?