Results 1 to 1 of 1

Thread: Office Version Independent Non-Activex Date Time Picker Using Form Controls

  1. #1
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10

    Office Version Independent Non-Activex Date Time Picker Using Form Controls

    I was working on a project which required a date and time control. As I expected, the MSComCtl.ocx, or the Microsoft Windows Common Controls 6.0 (SP4) did not work in many of the computers that the project was run on. As I searched the internet, I came across quite a few sites which have very good looking non-activex, non-MSCAL.OCX calendar forms, and hot discussions on the same.

    https://sites.google.com/site/e90e50...-control-class

    http://www.tushar-mehta.com/excel/software/tm_calendar/index.html

    ActiveX date and time picker not available in Excel 2010 - any alternatives? | LinkedIn

    But alas! None of them had a Time Picker (or nobody seemed to be really interested in time, and very mostly focused on date)

    Anyway, I put together this very very crude but reliable piece of interface that replicates an actual time picker control. It's really straight forward, but just be sure you which events to use to call the right forms to pick date and time. Until I am forced to work on a more close-to-original replica, or until I improve my googling skills, I'll leave this for your usage. In the same vein, let me emphasize that this is more of a developer's version than a production version.
    Attached Files Attached Files
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Non-ActiveX Calendar / MonthView Control
    By Excel Fox in forum Excel Ribbon and Add-Ins
    Replies: 1
    Last Post: 07-18-2013, 09:14 AM
  2. Freeze Time Using Excel Formula To Freeze Date
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 06-28-2013, 08:11 PM
  3. Populate Ribbon Controls On Load Dynamically Through VBA Variables
    By phxpoolplayer in forum Excel Ribbon and Add-Ins
    Replies: 1
    Last Post: 04-20-2013, 01:51 AM
  4. Date & Time Formats in Different Languages
    By Haseeb A in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 06-10-2012, 02:57 PM
  5. Displayin Date/Time in "original" time zone
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 04-21-2012, 02:02 AM

Posting Permissions

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