How To Download Excel Date Picker

Download microsoft date and time picker control.

How to download excel date picker. It does not require you to insert an additional control into any particular excel sheet. The date and time picker is part of a library of tools with the catchy title of mscomct2 ocx. Sadly microsoft have since removed this file from their site. To do this click the start button office button type mscomct2 ocx or mscal ocx in excel 2007 and earlier in the search box and click enter. Here introduce a useful tool the insert date utility of kutools for excel with this utility you can easily pick up dates with specific format from a date picker and insert in into selected cell with double clicking.

This has been a guide to an excel date picker. Microsoft date and time picker control 6 0 sp6 is not available for the 64 bit version of ms excel. If the mscomct2 ocx file is found skip the next step and proceed with step 3. Download free fully functional trial version. To start with you ll need to download this file from the microsoft support site.

Click this link on the page to start downloading the file. Pick a date value from a pop up calendar in microsoft excel using excel date picker. After writing the vba code we need to save the file with xlsm excel macro enabled workbook extension. Livio march 21 2018 excel excel vba 0 comments. Use browse to select the add in and then click on ok.

In the manage drop down choose excel add ins and click go. Otherwise the vba code would not run. Works for excel 2003 excel 2007 excel 2010 excel 2013 and excel 2016. Click on file click on options click the add ins tab. As long as the date picker app is running it activates the pop up calendar in all the excel files you open.

Date picker for excel inserts a pop up calendar into microsoft excel. Verify that the date picker is checked in the add in list and then click ok. For those users who are using the 64 bit versions of excel how can they solve this problem. Excel does not really provide a good way for the user to pick a date from a calendar when your application is running for my applications i had to come up with custom excel date picker.