Hi all, i believe that Microsoft Windows Common Controls 2-6.0 (SP6) is no longer used. We are upgrading from Office to Office 365, and as such, some of our Addin no longer run correctly due to the missing reference to Microsoft Windows Common Controls 2-6.0 (SP6) One of the problems i have is that Format(date, 'yyyy') no longer seems to work.
I am looking for a control to add to userForm to enable a user to pick the date. I found a good one at this address
from Siddharth Rout which is perfect but it generates invisible sheets which is not necessary for my application. I tried to stop creating sheets but I couldn't figure it out.
- Controls select microsoft monthview control 6 0 sp6 if applicablenozeesenpai.blogspot.de. Ici le code VBA nous montre comment affecter le choix de l'utilisateur. Excel VBA Calendar, DatePicker Stack Overflow.
- Date Picker for Excel inserts a pop-up calendar into Microsoft Excel. It works like a drop-down calendar, offering a handy date selector. As long as the date picker app is running, it activates the pop-up calendar in all the Excel files you open. It does not require you to insert an additional control into any particular Excel.
The tutorial shows how to insert a drop-down calendar in Excel (date picker) and link it to a specific cell. In the More Controls dialog window, find the Microsoft Date and Time Picker Control 6.0 (SP6), select it, and click OK. Download Microsoft Date and Time Picker control.
Can you please let me know how I can properly modify the Siddharth Rout code or point me to another application like that?
Thanks for your time
4 Answers
OFFICE 2013 INSTRUCTIONS:
(For Windows 7 (x64) MS Office 32-Bit)
Option 1 Check if ability already exists 2 minutes
Microsoft Date And Time Picker Download
- Open VB Editor
- Tools -> Additional Controls
- Select 'Microsoft Monthview Control 6.0 (SP6)' (if applicable)
- Use 'DatePicker' control for VBA Userform
Option 2 The 'Monthview' Control doesn't currently exist 5 minutes
- Close Excel
- DownloadMSCOMCT2.cab (it's a cabinet file which extracts into two useful files)
- Extract Both Files the .inf file and the .ocx file
- Install right-click the .inf file hit 'Install'
- Move .ocx file Move from 'C:Windowssystem32' to 'C:WindowssysWOW64'
- Run CMD Start Menu -> Search -> 'CMD.exe' right-click the icon Select 'Run as administrator'
- Register Active-X File Type 'regsvr32 c:windowssysWOW64MSCOMCT2.ocx'
- Open Excel Open VB Editor
- Activate Control Tools->References Select 'Microsoft Windows Common Controls 2-6.0 (SP6)'
- Userform Controls Select any userform in VB project Tools->Additional Controls
- Select 'Microsoft Monthview Control 6.0 (SP6)'
- Use 'DatePicker' control for VBA UserForm
Okay, either of these two steps should work for you if you have Office 2013 (32-Bit) on Windows 7 (x64). Some of the steps may be different if you have a different combo of Windows 7 & Office 2013.
The 'Monthview' control will be your fully fleshed out 'DatePicker'. It comes equipped with its own properties and image. It works very well. Good luck.
Site: 'bonCodigo' from above (this is an updated extension of his work)
Site: 'AMM' from above (this is just an exension of his addition)
Site: Various Microsoft Support webpages
You could try the 'Microsoft Date and Time Picker Control'.To use it, in the Toolbox, you right-click and choose 'Additional Controls...'.Then you check 'Microsoft Date and Time Picker Control 6.0' and OK.You will have a new control in the Toolbox to do what you need.
I just found some printscreen of this on :http://www.logicwurks.com/CodeExamplePages/EDatePickerControl.htmlForget the procedures, just check the printscreens.
Microsoft Date And Time Picker Control 6 0 Sp6
In Access 2013.Drop a 'Text Box' control onto your form.On the Property Sheet for the control under the Format tab find the Format property.Set this to one of the date format options.Job's done.
Date And Time Picker Jquery
Just throw some light in to some issues related to this control.
Date picker is not a standard control that comes with office package. So developers encountered issues like missing date picker controls when application deployed in some other machiens/versions of office. In order to use it you have to activate the reference to the .dll, .ocx file that contains it.
In the event of a missing date picker, you have to replace MSCOMCT2.OCX file in System or System32 directory and register it properly. Try this link to do the proper replacement of the file.
In the VBA editor menu bar-> select tools-> references and then find the date picker reference and check it.
If you need the file, download MSCOMCT2.OCX from here.
protected by Community♦Nov 8 '16 at 7:11
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
Not the answer you're looking for? Browse other questions tagged vbaexcel-vbaexcel or ask your own question.
Since few days I have tried to apply this ActiveX to my Excel 2013.I made small app for running reports in Excel and I need some way to pick start and end date.
Easiest way to do it was Date And Time Picker Control which is in %windir%syswow64mscomct2.ocx.It worked perfectly at Windows 7 64-bit + Excel 2010 32-bit.
When I moved my project to other PC with Windows 7 64-bit and Office 2013 32-bit it stopped working. Firstly there was class missing, so I registered Microsoft Windows Common Controls 2 6.0 (SP3) in syswow64 using regsvr32.exe command.
It did not help - it was keep saying 'cannot insert object'.Tried another versions of Common Controls (currently SP6), but problem is still there - I can`t put any control to my Excel worksheet.
I`m running out of ideas and tutorials, so maybe some of You had ran into this type of problem and have solution?
1 Answer
It's best that you just abandon your search for a Microsoft solution. They haven't updated the common controls for 64-bit. Your best options are to create your own ActiveX Control by wrapping the Date And Time Picker Control from .Net or communicate using COM and expose the features that you want, or use one of the custom VBA solutions that can be found on Ron de Bruin's Calendar/Date Picker page.
I've used this one - Calendar Control for All Office versions - including Office 2010 64 bit
but this one looks better IMO - A Pop-up Calendar for Excel 2007 and up
Even if you can get it running on your machine, if you work at a large company, like myself, you'll never get IT to deploy the fix to everyone.
Edit: was getting confused with MSCOMCTL.OCX issues
Not the answer you're looking for? Browse other questions tagged vbadatepickerexcel-2013 or ask your own question.
I am looking for a control to add to userForm to enable a user to pick the date. I found a good one at this address
from Siddharth Rout which is perfect but it generates invisible sheets which is not necessary for my application. I tried to stop creating sheets but I couldn't figure it out.
The tutorial shows how to insert a drop-down calendar in Excel (date picker) and link it to a specific cell. In the More Controls dialog window, find the Microsoft Date and Time Picker Control 6.0 (SP6), select it, and click OK. Download Microsoft Date and Time Picker control.
Can you please let me know how I can properly modify the Siddharth Rout code or point me to another application like that?
Thanks for your time
4 Answers
OFFICE 2013 INSTRUCTIONS:
(For Windows 7 (x64) MS Office 32-Bit)
Option 1 Check if ability already exists 2 minutes
Microsoft Date And Time Picker Download
- Open VB Editor
- Tools -> Additional Controls
- Select 'Microsoft Monthview Control 6.0 (SP6)' (if applicable)
- Use 'DatePicker' control for VBA Userform
Option 2 The 'Monthview' Control doesn't currently exist 5 minutes
- Close Excel
- DownloadMSCOMCT2.cab (it's a cabinet file which extracts into two useful files)
- Extract Both Files the .inf file and the .ocx file
- Install right-click the .inf file hit 'Install'
- Move .ocx file Move from 'C:Windowssystem32' to 'C:WindowssysWOW64'
- Run CMD Start Menu -> Search -> 'CMD.exe' right-click the icon Select 'Run as administrator'
- Register Active-X File Type 'regsvr32 c:windowssysWOW64MSCOMCT2.ocx'
- Open Excel Open VB Editor
- Activate Control Tools->References Select 'Microsoft Windows Common Controls 2-6.0 (SP6)'
- Userform Controls Select any userform in VB project Tools->Additional Controls
- Select 'Microsoft Monthview Control 6.0 (SP6)'
- Use 'DatePicker' control for VBA UserForm
Okay, either of these two steps should work for you if you have Office 2013 (32-Bit) on Windows 7 (x64). Some of the steps may be different if you have a different combo of Windows 7 & Office 2013.
The 'Monthview' control will be your fully fleshed out 'DatePicker'. It comes equipped with its own properties and image. It works very well. Good luck.
Site: 'bonCodigo' from above (this is an updated extension of his work)
Site: 'AMM' from above (this is just an exension of his addition)
Site: Various Microsoft Support webpages
You could try the 'Microsoft Date and Time Picker Control'.To use it, in the Toolbox, you right-click and choose 'Additional Controls...'.Then you check 'Microsoft Date and Time Picker Control 6.0' and OK.You will have a new control in the Toolbox to do what you need.
I just found some printscreen of this on :http://www.logicwurks.com/CodeExamplePages/EDatePickerControl.htmlForget the procedures, just check the printscreens.
Microsoft Date And Time Picker Control 6 0 Sp6
In Access 2013.Drop a 'Text Box' control onto your form.On the Property Sheet for the control under the Format tab find the Format property.Set this to one of the date format options.Job's done.
Date And Time Picker Jquery
Just throw some light in to some issues related to this control.
Date picker is not a standard control that comes with office package. So developers encountered issues like missing date picker controls when application deployed in some other machiens/versions of office. In order to use it you have to activate the reference to the .dll, .ocx file that contains it.
In the event of a missing date picker, you have to replace MSCOMCT2.OCX file in System or System32 directory and register it properly. Try this link to do the proper replacement of the file.
In the VBA editor menu bar-> select tools-> references and then find the date picker reference and check it.
If you need the file, download MSCOMCT2.OCX from here.
protected by Community♦Nov 8 '16 at 7:11
Microsoft Monthview Control 6 0 Sp6 Excel 2013 Download Utorrent
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
Not the answer you're looking for? Browse other questions tagged vbaexcel-vbaexcel or ask your own question.
Since few days I have tried to apply this ActiveX to my Excel 2013.I made small app for running reports in Excel and I need some way to pick start and end date.
Easiest way to do it was Date And Time Picker Control which is in %windir%syswow64mscomct2.ocx.It worked perfectly at Windows 7 64-bit + Excel 2010 32-bit.
When I moved my project to other PC with Windows 7 64-bit and Office 2013 32-bit it stopped working. Firstly there was class missing, so I registered Microsoft Windows Common Controls 2 6.0 (SP3) in syswow64 using regsvr32.exe command.
It did not help - it was keep saying 'cannot insert object'.Tried another versions of Common Controls (currently SP6), but problem is still there - I can`t put any control to my Excel worksheet.
I`m running out of ideas and tutorials, so maybe some of You had ran into this type of problem and have solution?
1 Answer
It's best that you just abandon your search for a Microsoft solution. They haven't updated the common controls for 64-bit. Your best options are to create your own ActiveX Control by wrapping the Date And Time Picker Control from .Net or communicate using COM and expose the features that you want, or use one of the custom VBA solutions that can be found on Ron de Bruin's Calendar/Date Picker page.
I've used this one - Calendar Control for All Office versions - including Office 2010 64 bit
but this one looks better IMO - A Pop-up Calendar for Excel 2007 and up
Even if you can get it running on your machine, if you work at a large company, like myself, you'll never get IT to deploy the fix to everyone.
Microsoft Monthview Control 6.0 Sp6 Excel 2013 Download
Edit: was getting confused with MSCOMCTL.OCX issues