Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: active x calendar control

  1. #1
    Board Regular
    Join Date
    Jan 2012
    Posts
    152
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default active x calendar control

    Not sure if this the correct location to post this question. So if not, my apologizes. I'm running excel 2010 and can't locate the calendar control within it (activex or userform). I started to search different websites after I googled issue. One site suggested that I go here:Office Dev Center Home to find the download needed but this question was posted in 2003 and I couldn't locate the necessary download. One more thing, this control would need to work with earlier versions of excel (i.e. 2002). Thanks to all who contribute. Posted this question on other similar forums.

  2. #2
    Board Regular
    Join Date
    Aug 2011
    Location
    AMS
    Posts
    1,911
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: active x calendar control

    have a look at Excel Tips: Put a Calendar Date Picker on an Excel Worksheet

    I think its the Microsoft Date and Time Picker Control what you looking for but have no idea if it would be compatible with earlier versions as 2003??

  3. #3
    Board Regular
    Join Date
    Jan 2012
    Posts
    152
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: active x calendar control

    option not listed. Running office 2010 university if that makes a difference. Thanks for quick reply.

  4. #4
    Board Regular
    Join Date
    Dec 2005
    Location
    Wisconsin
    Posts
    205
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: active x calendar control

    In the 2010 version select the Insert, Active X Controls on the Developer Tab. There should be three little dots in the lower right hand corner of the Active X Controls. Click on the dots and select Microsoft Date and Time Picker.

  5. #5
    Board Regular
    Join Date
    Aug 2011
    Location
    AMS
    Posts
    1,911
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: active x calendar control

    yeah you have to install it How to Install Microsoft Date & Time Picker Control 6.0 (SP4) | Daniel B. Curran Jr.

    but a better way which i implemented is to use a Calendar Class https://sites.google.com/site/e90e50...-control-class

  6. #6
    Board Regular
    Join Date
    Aug 2011
    Location
    AMS
    Posts
    1,911
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: active x calendar control

    forgot to mention the Calendar Class is also working in Word but you need some tweaking on the code I've implemented it in the first place for Word Forms where we needed a date picker for all versions across several countries and for hundrets of customers.

    You can't expect that they all download and install the Active x Controls if they are n/a with their local install.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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