Installing the Date Picker

why do you post answers to things that you don't have an answer for . your answer is 100% wrong. you are wasting peoples time. you should make sure you know what you are talking about before you post. this answer is correct if you have anything but excel 2010 with windows 7 x64.

Sensible answer Chris. I used it extensively a decade ago and it was great. Fantastic piece of programming. Now, for most of us, date picker is a non event. As some say, there are other options out there now to fill the gap if you really need one. This tip should now be deleted. It keeps systematically reappearing with the same answers and same frustrations.

So to save everybody some time, why not start by saying "If you are running a x64 bit system, you cannot follow these steps"??

Very good information. Thank you Allen Wyatt

Lynn

John Walkenbach has a yearly calandar that can be downloaded from his site at:
http://spreadsheetpage.com/index.php/file/yearly_calendar_with_holidays/

I have created a list of events on another sheet and used conditional formatting to highlight specific dates; perhaps this will be helpful too you

Good luck

And, of course, I have Win10 and Office14 both of which are 64-bit. I have scoured the internet sleeplessly for solutions to why I don't have DatePicker Tool. They all indicated all I needed to do was register an .ocx file and presto. Never worked and apparently never will.
Can you tell me how I can determine if MS has produced a 64-bit version? I'm not a techie, just a home tinkerer trying to add a calendar to a spreadsheet used to track my son's diabetes.

tnx

I have created a excel sheet with date and time picker feature using MSOffice 2013.
When we distribute this excel sheet to other users who are using MSOffice 2007 it doesn't works for them.
Please suggest what to do from my end in my laptop having MSOffice 2013 to make the date and time picker feature workable to all other users in our branches PAN India having MSOffice 2007.

Thanks
Sekar s

Thank you very much Mr. Gary.
Other solutions can be used instead of date picker control. As an example, I created a between dates filtering template and used the date user form instead of the date picker.

Template can be viewed here : https://youtu.be/-RdSZsn2KmU

Mine was working and then all of a sudden it's dead. It won't respond when I click on it. Any ideas?

Thank you!

Gary

Thank you very much. I've been trying to install Mscomct2.ocx for the whole evening, going through dozens of web sites to no avail. I didn't know it doesn't work with office 64 bit. You explained it clearly and voila, I found the solution. Thank you very much.

Thank you Allen and Richard! I have finally been able to get the Date Picker to work, something I've tried to get for quite a while now.

One question- is there a way to change the font size of the date displayed in the tool? It is rather large. I can change the size of the box by dragging the corner, and can change the font, but I don't see an option for the actual font size.

Thank you!

Gary

Date Picker Alternatives For 64-Bit Office: Several "private" solutions have been posted on varoius forms. These are not official Microsoft solutions, but users of the 64-bit systems said they worked:

http://xltools.net/excel-popup-calendar/

https://jumpshare.com/b/O5FC6LaBQ6U3UPXjOmX2

If you want to stay with Microsoft offerings and you are running Office 32 bit, then keep reading the article below.

Important Note: The Active-X Date Picker can be registered for Office 2010 32-bit, but it will not work on Office 2010-64-bit. Developers who use the Date Picker are advised to stay with the 32-bit version of Office 2010. There is no official replacement for the much-loved date picker in the 64-bit version of Office 2010, as shown in the following article and forum post by Microsoft:

Date Picker 2015 Fixes For Active-X Issues

No Formal Date Picker For Office 2010-64bit As Of July 2012

I understand your TIPS clumn is for 2007, 2010, and 2013. I hope, though you can help with Excel 2016.

I cannot find the date picker in Excel 2016. I looked in the ActiveX More Controls drop down, but no luck.

Also, How do I determine if my Excel is 32 or 64 Bit?

I tried everything mentioned here but with no success. I cannot use command buttons of existing Excel 2010 files running on Vista Home Premium SP2 after a Windows update was done.Prior to this I had no problems.PLEASE HELP!!!

I AM ABLE TO VARY AND CHOSE DATE ON CALENDER, BUT HOW DO I VARY AND PICK HOURS

I am able to get the floating calendar to work fine but I need other users to be able to rename the file and have the calendar function still work. If the user renames the file the calendar no longer works as it is looking for the original file name. If the original file is in the same directory it opens that file but shows the calendar on the renamed file. I am using MS Office 2013.

Followed instructions above, running on 64 bit Windows & Office 32 bit, registered the MSCOMCT2.OCX in C:WindowsSysWOW64 but still getting 'cannot insert object' with Microsoft Date and Time Picker Control 6.0 (Sp6) keep getting. Any ideas anyone?

I do not have the date picker option. Instead I have Calendar Control 12.0. I am able to install a calendar and it works on my machine but when others open the spreadsheet the calendar will not allow them to select a date. Any idea why?

Where can I download MSCOMCT2.OCX? It's not on my system, (Win 8.1, 64 bit).
I need to install a calendar control. Had no problem doing so with Excel 2002!
This is nuts.

Can any one help I have tried to insert this control into a worksheet I get an error "Cannot Insert Object".

As far as I am aware I have registered the MSCOMCT2.OCX correctly.

be sure to exit design mode to use the date picker

I followed all of these instructions; however; when I click in a cell and then select a date in the date picker, the date changes in the date picker, but no date is put into the cell I was in before selecting the date. It remains blank.

What am I doing wrong? I am in 32-bit Office 2013

Gary

Hi can anyone tell me what is its usage? Am I using it without knowing about it?or is it something which I already know?

With Regards
Rudra

Microsoft, why does getting date picker have to be so difficult? Why can't you simply include it as a standard option under Data Validation?

The 4-headed cursor shows you are still in 'Design Mode'. So right-click the mouse, and select the option 'View code'.
You should see something like this in the VBA editor window:
Private Sub MonthView21_DateClick(ByVal DateClicked As Date)

End Sub

add a line so that it looks like this:
Private Sub MonthView21_DateClick(ByVal DateClicked As Date)
activecell.value = DateClicked
End Sub

Now return to the worksheet (press [Alt][F11] ). Come out of 'Design Mode' by clicking 'Design Mode' in the top-panel Ribbon on the 'Developer' tab.

If you can't see the 'Developer' tab in the top-panel Ribbon, do this:
>Go back to the VBA Editor [Alt][F11]
>Go to Immediate Window [Ctrl][G]
>enter this line, and then press [Enter]
Application.ShowDevTools=True
>Return to Excel worksheet [Alt][F11]
Come out of 'Design Mode' by clicking 'Design Mode' in the top-panel Ribbon on the 'Developer' tab.

Now, put cellpointer in any cell, then click a date on the Calendar. It will be placed into the active cell. If it shows as ####### just make the column wider to show the date.

That's it.

I have the same question as Barry.

I am running Office 2010 on 32-bit Vista and do have the Microsoft Date and Time Picker tool. But how does it work? I inserted it on a spreadsheet, but whenever I move my cursor over it, the cursor changes to a 4-headed arrow which only allows me to move it around. How can I use it to choose a date?