Date picker

[LordVoldetort_IV]

Hello!

i am working on a sheet where i require a date picker, i currently am working on office 2016.

I used activex date picker and this is what it said in that cell when i select it : =EMBED("MSComCtl2.DTPicker.2","")

It work 100% for me.

i asked a coworker to have a look at the sheet, he is using office 2019, and he could not see the date picker, it appeared as a white box.

i need a workaround please, a date picker of the like is crucial and i need it to work no matter what excel version you use

date format should be yyyy/mm/dd

should be able to link another cell to the date picker

VBA or other options welcome

 

[KOKOSEK]

Recommend calendar picker

 

[LordVoldetort_IV]

Thank you Kokosek, the picker works,

How do i get the answer of the picker to fill into cell "K16" on the sheet named "Info sheet"

 

[KOKOSEK]

in 'Info sheet' code put:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Intersect(Target, [K16]) Is Nothing Then
    Target.value = CalendarForm.GetDate
    Cancel = True
End If
End Sub

that's action for double click in cell K16.

 

[LordVoldetort_IV]

okay perfect, thank you very much!