+ Reply to Thread
Results 1 to 4 of 4

use datepicker without mscomct2.ocx

  1. #1
    Registered User
    Join Date
    04-10-2010
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    2

    use datepicker without mscomct2.ocx

    I've recently found out that the Microsoft Windows Common Controls 2 6.0 (sp6) is not installed with Office 2007 as standard and was wondering if theres any alternative to the datepicker on a userform that i can use that DOES come as standard.

    I find it annoying how such an important and common control would not be included as a standard control.
    Thanks
    Last edited by johnsmith22; 04-10-2010 at 10:08 AM. Reason: extra info

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: use datepicker without mscomct2.ocx

    Alternative suggestions here

    http://excel-it.com/free_addins.htm
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    04-10-2010
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: use datepicker without mscomct2.ocx

    The problem with using an addon is that I want the excel file to be used on other workstations and don't want the user to have to download anything. I want to use what would already be available on their system

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: use datepicker without mscomct2.ocx

    There are other suggestions there

    There is also an example of how to use the ActiveX Calendar Control Another way would be to use ComboBoxes on a UserForm, get an example here or a UserForm calendar is available with code & examples of how to use it. Free download...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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