+ Reply to Thread
Results 1 to 4 of 4

Date picker control for Excel 2003 userform

  1. #1
    Registered User
    Join Date
    06-09-2011
    Location
    Newcastle, Australia
    MS-Off Ver
    2003, 2010
    Posts
    54

    Question Date picker control for Excel 2003 userform

    I cannot find a date-picker control for an Excel 2003 UserForm -- despite searching the web

    I think I have a UserForm as a date picker but a MS OLE control would be slicker and less bloat
    I suspect all current web pages are 2007/2010 focused.

    Is there a download for a date-picker. I do not want a worksheet date picker, there are several of those around.

    One lead quotes "Calendar Control 11.0"

    Would appreciate any help ... thank you

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Date picker control for Excel 2003 userform

    Hello GreyGhost,

    It should be in the "Additional Controls" which can be added to the UserForm "Controls" Toolbox.
    1. . Be sure you have a UserForm added to your workbook.
    2. . Display the "Toolbox".
    3. . Right click on any control icon.
    4. . Click "Additional Controls..." in the context menu.
    5. . Scroll down the list until you find "DT Picker Control".
    6. . Click the square box on the left to select the control.
    7. . Click "OK". the control will now be added to the "Toolbox".
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    06-09-2011
    Location
    Newcastle, Australia
    MS-Off Ver
    2003, 2010
    Posts
    54

    Re: Date picker control for Excel 2003 userform

    Thank you Leith Ross for your reponse,

    Not listed on my Office 2003 (WinXP) rig

    no DT Picker Control_2.bmp
    -----
    EDIT BMP file is a dead loss, just opened it on my Win7 laptop and it auto opened in "old" WinXP "Paint"
    (My WinXP rig cannot be connected to web, contractual condition with clients)
    I will try for a PNG file and post back here in a new post. Sorry about this.
    -----
    I have just found "mscomct2.ocx" (with "mscomct2.inf")

    I am out of my depth here ...would these files help
    They came as "mscomct2.cab" and in my haste I did not document the URL source.
    Source:= http://support.microsoft.com/kb/297381/en-us
    Without instructions how to install. I think it is a cmd install ? (Dont quote me)

    I appreciate your help
    Last edited by GreyGhost; 01-19-2014 at 06:00 PM.

  4. #4
    Registered User
    Join Date
    06-09-2011
    Location
    Newcastle, Australia
    MS-Off Ver
    2003, 2010
    Posts
    54

    Re: Date picker control for Excel 2003 userform

    New PNG image of missing :DT Date Picker Control

    no DT Picker Control.PNG

+ 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. Date picker UserForm to stay always in front of the main UserForm
    By Gabor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2014, 07:31 AM
  2. Date and Time Picker Control 6.0 (SP6)
    By jj554 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-18-2013, 08:47 PM
  3. Date Picker Control
    By SP Brian in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-07-2012, 02:43 AM
  4. Problem with Date Picker control in Excel
    By AK.Ponnekanti in forum Excel General
    Replies: 0
    Last Post: 07-07-2006, 12:10 AM
  5. Date / Time Picker V6.0 - Control moves location on userform!
    By Mark in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-03-2005, 11:05 AM

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