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
A date picker is a control that lets users quickly enter dates in a Microsoft Office InfoPath form by clicking a small pop-up calendar. For example, you can use a date picker to collect birth dates from people on an insurance form.
Drop-down Calendar mode (default) – enables the user to display a drop-down calendar that can be used to select a date. Time Format mode – enables the user to select a field in the date display (such as, the month, day, year, and so forth), and press the UP or DOWN arrow to the right of the control to set its value.
When creating your own user interfaces within Excel, the various developer controls can add a nice touch. One such control is the date picker, which allows you (oddly enough) to pick dates. This control doesn't work with all recent versions of Excel, however. Here's the scoop.
Aug 05, 2019 How to install Microsoft Date and Time Picker Control 6.0 (SP6) in Window 8. Microsoft Office Excel IT Pro Discussions.
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.
Can you please let me know how I can properly modify the Siddharth Rout code or point me to another application like that?
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
Microsoft Date And Time Picker Control 6.0 (sp4) Download
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.
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.
FW55FW55
Microsoft Date Time Picker Control
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.
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?
Microsoft Date Picker Control Excel 2013
Not the answer you're looking for? Browse other questions tagged vbaexcel-vbaexcel or ask your own question.