DTPicker Control in MS365 64-bit

Denny57

Board Regular
Joined
Nov 23, 2015
Messages
246
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

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
You cannot, as far as I know, use that control in 64bit Office.
 
Upvote 0

Forum statistics

Threads
1,224,811
Messages
6,181,082
Members
453,021
Latest member
Justyna P

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