+ Reply to Thread
Results 1 to 3 of 3

Date Picker download for Excel 2007

  1. #1
    Registered User
    Join Date
    10-04-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Date Picker download for Excel 2007

    Hi,

    Is there a way to download Windows Common Controls-2 6.0 for free to gain access to the Date Picker control? Or do you have to pay for it?

    Thanks,
    Mark

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2505 Win 11
    Posts
    24,754

    Re: Date Picker download for Excel 2007

    Here is what I use for a Date Picker.

    http://www.fontstuff.com/excel/exltut03.htm

    And it will only take a few minutes to build and it is Free.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    10-04-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Date Picker download for Excel 2007

    Thanks Alan,

    I started using this method but soon realized I don't have 'Microsoft Date and Time Picker Control 6.0 (SP6)' as an option under more controls. I then started to follow his VBA tutorial 'A pop up Calendar for Excel' and found the additional controls did not have 'Microsoft MonthView Control 6.0 (SP4)'.

    After some searching I concluded that I need to download Windows Common Controls-2 6.0 as this is not included with Excel 2007 and within those controls is mscomct2.ocx which will then enable the date picker control option.

    Several links that I have tried to download from keep popping up with an option for a 40 day trial period for a WinRAR license or to buy it.

    I'm happy to pay for it if that is what I need to do but just wanted to see if there is a free download somewhere that I am not aware of?

    Thanks again,
    Mark

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA Excel 2007 Date Picker keeps uninstalling - Help?
    By danmarson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-03-2013, 04:48 AM
  2. File picker in excel 2007
    By irfanparbatani in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-14-2012, 12:01 AM
  3. Use Calendar (Excel 2007) and the Date Picker (Excel 2010) in same project...
    By jpcsolutions in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-18-2011, 01:52 AM
  4. Date Picker in Excel 2007
    By RJMooreII in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-03-2010, 02:09 PM
  5. Excel Date Picker
    By Wshadow in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-12-2008, 01:12 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1