Using Datepicker in Userform VBA compatible to Excel 2013 64bit and 2007 32bit

Hi everyone,

I need to create a userform activity record by date.xlsm where i want to change the textbox1 into datepicker so that I don't have to type it incoherently.

Furthermore, the file is intended compatible with two versions of Microsoft Office Excel to work with, namely 2013 version with 64-bit and 2007 version with 32-bit.

I have been trying to change the textbox1 into datepicker for weeks already as I am unable to find solution.

Appreciate for helping me on this one.

Thanks.