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
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