#TIME AND DATE PICKER FOR EXCEL 2010 64 BIT 64 BIT#
I also have Excel 2010 64 bit installed on my computer but that does not have the Microsoft Date and Time Picker either.
and then installed that in Windows\System32. I now have this file in box the Windows\System32 folder and the Windows\SysWOW64 and I have registered both, but it still does not show up as an additional control that I can select.Īs I mentioned Windows\SysWOW64 already had this file so I downloaded another file from a link suggested in the book: * You should get a message saying this succeeded. * Type the following and then press Enter: regsvr32 mscomct2.ocx * Change directory to the folder where you extracted the files. * Right-click Command Prompt and then click on Run As Administrator. I found this file in the folder C:\Windows\SysWOW64and registered using the instructions I found at this site: There are many check boxes for additional controls, but this particular control is not listed.Īpparently a file MSCOMCT2.OCX needs to be registered.
This control has to be added to the control toolbox from the Additional Control menu - specifically the Microsoft Date and Time Picker Control 6.0. Date & Time Picker - Overview Download the Date & Time Picker files - latest version Importing VBA Files Integration - Binding the Date picker to User Form. The first exercise is too create a user form with the ActiveX Date and Time Picker Control. With this tool, you can insert any date and time in. I am at chapter 19: Creating Custom forms In Microsoft Excel, many essential tools create a great user experience. I am working my way through the exercises in a book called Excel 2010 Programming by Example with VBA, XML and ASP.
0 kommentar(er)
