+ Reply to Thread
Results 1 to 4 of 4

DTPicker won't appear?

  1. #1
    Registered User
    Join Date
    03-31-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    10

    DTPicker won't appear?

    I'm at a complete loss. I previously created a form using the dtpicker. Now, however i am using a different computer and microsoft office 'enterprise' edition. When i open my previously created workbook, the dtpicker is a large box with a red 'x'.

    In most cases i would say this is a macros security issue, however i've enable macros and all active x controls and still cannot get things to appear properly. I'm likely overtired and just missing the obvious, but i really need to get this to work, with a deadline breathing down my throat.

    Any ideas?

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: DTPicker won't appear?

    Sounds like the control is missing (probably not installed).

    Date Picker Control Missing

  3. #3
    Registered User
    Join Date
    03-31-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: DTPicker won't appear?

    Thanks for your help. It looks like i cannot do what i wanted with this control, if it won't be readily available on any old computer. I've created my own pop-up calendar in VB, which has created it's own set of challenges. I appreciate your help!

  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: DTPicker won't appear?

    There's alternatives available here

    http://excel-it.com/free_addins.htm

    See the section on the DtaePicker, the last paragraph contains links to alternative examples
    Hope that helps.

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

    Free DataBaseForm example

+ 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