DTPicker Control in MS365 64-bit

Denny57

Board Regular
Joined
Nov 23, 2015
Messages
185
Office Version
  1. 365
Platform
  1. Windows
I have read that the DTPicker control is only available for MS365 32-bit, however I have read that it is possible to use in the 64-bit version by doing the following:-
1) Download mscomctl.ocx
2) Copy the file to C:\Windows\sysWOW64
3) Using Powershell as administrator
a) change the drive to C:\Windows\sysWOW64
b) type regsvr32 mscomctl.ocx and ENTER to register the file

I have completed this and received the expected "success" message box but cannot see the DT Picked in the VBA controls.

I have searched Tools - Resources for the "MS Windows Common Controls" which it where I have found this in a 32 Bit version but cannot find this.

Please can anyone advise where the content of msconctl.ocx should be visible in Excel or alternatively is there a date picker control which is available in 64-bit 365 which I can use to replace the existing DTPicker control I have in various user forms and corresponding VBA Code.

Many thanks
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
You cannot, as far as I know, use that control in 64bit Office.
 
Upvote 0

Forum statistics

Threads
1,215,068
Messages
6,122,950
Members
449,095
Latest member
nmaske

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top