+ Reply to Thread
Results 1 to 6 of 6

Add Date Picker to additional controls Excel 2010

  1. #1
    Registered User
    Join Date
    11-29-2009
    Location
    dubai
    MS-Off Ver
    Excel 2003
    Posts
    56

    Add Date Picker to additional controls Excel 2010

    Hi,

    Can anyone tell me how to add date picker to additional controls. system configuration below.

    OS - Win 7 Pro 64 Bit
    Excel 2010 - 32 bit

    Thanks
    R

  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: Add Date Picker to additional controls Excel 2010

    Excel 2010 does not support this Control.

    Using it in any version of Excel can be problematical, see alternatives here
    Last edited by royUK; 08-17-2011 at 08:22 AM.
    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
    11-29-2009
    Location
    dubai
    MS-Off Ver
    Excel 2003
    Posts
    56

    Re: Add Date Picker to additional controls Excel 2010

    Quote Originally Posted by royUK View Post
    Excel 2010 does not support this Control.

    Using it in any version of Excel can be problematical, see alternatives here
    If I click on the alternatives link it open a blank page.
    Thanks for replyin

    R

  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: Add Date Picker to additional controls Excel 2010

    Fixed now, sorry

  5. #5
    Registered User
    Join Date
    09-17-2012
    Location
    NJ, USA
    MS-Off Ver
    Excel 2007/2010
    Posts
    3

    Re: Add Date Picker to additional controls Excel 2010

    hi Roy, I have the same config as rvc81 above:

    OS - Win 7 Pro 64 Bit
    Excel 2010 - 32 bit

    I installed JR_DatePicker but...(1) it does not come up in the additional controls, and (2) a new password protected object is now in my project.

  6. #6
    Registered User
    Join Date
    09-29-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Add Date Picker to additional controls Excel 2010

    Yes this is possible. The feature is inbuilt into Excel 2010. Refer this link http://danielcurran.com/instructions...choose-a-date/
    Though the screenshots and the method is shown for Excel 2007, the feature remains same in Excel 2010. The only difference is the place from which you need to enable the developer tab in the the 2010 version .

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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