- VBA Project-Toolbox-Addtional Controls-Missing the Microsoft MonthView Control 6 option I am building a form and need the Microsoft MonthView Control 6 (SP4) option to insert a calendar for choosing a date.
- On the dialog box which appears, check the box next to the entry for the Microsoft Date and Time Picker Control 6.0. You'll find that you have access to several other controls from the mscomct2.ocx library as well.
- The first exercise is too create a user form with the ActiveX Date and Time Picker Control. 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. There are many check boxes for additional controls, but this particular control is not listed.
- Calendar Control v1.1.0 DatePickerOnly v2 - DatePicker Popup Advanced Positioning It is a simple change in the DatPicker form: The window appears near the clicked cell, and never out of the screen. Regardless of the Application or the Active Window is maximized or moved away or maximized. Calendar Control v1.1.0 - with simple DatePicker Popup Form!
I am using Office 365, Excel 2013 32 bit and trying to add an MS Date Time Picker Control 6.0 (SP6) to a worksheet. Clean your mac free. I can find the control listed under Developer - Insert - More Controls. I can select it. https://subscatordo.tistory.com/13. When I attempt to drop it onto the Excel worksheet I receive a message 'Cannot insert object.'
Microsoft Monthview Control 6.0 Excel 2013 Missing
Harry Flashman
Active Member
Microsoft Monthview Control 6 0 Excel 2013 Missing Word
I am working my way through the exercises in a book called Excel 2010 Programming by Example with VBA, XML and ASP.
I am at chapter 19: Creating Custom forms
The first exercise is too create a user form with the ActiveX Date and Time Picker Control.
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. There are many check boxes for additional controls, but this particular control is not listed.
Apparently a file MSCOMCT2.OCX needs to be registered. I found this file in the folder C:WindowsSysWOW64and registered using the instructions I found at this site:
Access 2010 Datepicker control missing
These were the instructions:
Go to StartAll ProgramsAccessories.
* Right-click Command Prompt and then click on Run As Administrator.
* Change directory to the folder where you extracted the files. For example, type the following and then press Enter: cd c:windowssystem32
* Type the following and then press Enter: regsvr32 mscomct2.ocx
* You should get a message saying this succeeded.
I now have this file in box the WindowsSystem32 folder and the WindowsSysWOW64 and I have registered both, but it still does not show up as an additional control that I can select.
As I mentioned WindowsSysWOW64 already had this file so I downloaded another file from a link suggested in the book:
http://activex.microsoft.com/controls/vb6/mscomct2.cab
.. and then installed that in WindowsSystem32.
I also have Excel 2010 64 bit installed on my computer but that does not have the Microsoft Date and Time Picker either.
Has anyone else been through this process and know what to do? Any assistance would be greatly appreciated.
Cheers.
I am at chapter 19: Creating Custom forms
The first exercise is too create a user form with the ActiveX Date and Time Picker Control.
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. There are many check boxes for additional controls, but this particular control is not listed.
Apparently a file MSCOMCT2.OCX needs to be registered. I found this file in the folder C:WindowsSysWOW64and registered using the instructions I found at this site:
Access 2010 Datepicker control missing
These were the instructions:
Go to StartAll ProgramsAccessories.
* Right-click Command Prompt and then click on Run As Administrator.
* Change directory to the folder where you extracted the files. For example, type the following and then press Enter: cd c:windowssystem32
* Type the following and then press Enter: regsvr32 mscomct2.ocx
* You should get a message saying this succeeded.
I now have this file in box the WindowsSystem32 folder and the WindowsSysWOW64 and I have registered both, but it still does not show up as an additional control that I can select.
As I mentioned WindowsSysWOW64 already had this file so I downloaded another file from a link suggested in the book:
http://activex.microsoft.com/controls/vb6/mscomct2.cab
.. and then installed that in WindowsSystem32.
I also have Excel 2010 64 bit installed on my computer but that does not have the Microsoft Date and Time Picker either.
Has anyone else been through this process and know what to do? Any assistance would be greatly appreciated.
Cheers.