+ Reply to Thread
Results 1 to 7 of 7

"Element not found" - Date and Time Picker (SP2)

  1. #1
    Forum Contributor
    Join Date
    04-11-2005
    Location
    London
    Posts
    259

    "Element not found" - Date and Time Picker (SP2)

    Hi

    I'm trying to use the date/time picker in the Microsoft Forms 2.0 Object Library and am getting the error message "Element Not Found".

    Having done a fair amount of searching on the internet, the conventional wisdom seems to be

    1. re-register MSCOMCT2.OCX- making sure that it is sited in SysWOW64 and not System32 (not sure why that would make a difference!)

    And from Excel...

    2. Add a reference to the Microsoft Forms 2.0 Object Library; using "Browse" to make sure you pick the correct one.

    3. Add the control to the Toolbox.

    4. Drop the control onto the form.

    However, despite numerous posts saying that this method works, I am still getting the "Element not found" message.

    Any help greatly appreciated.

    Martin
    Martin Short

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: "Element not found" - Date and Time Picker (SP2)

    I thought MS has removed it from excel 2010 ( From my memory)

  3. #3
    Forum Contributor
    Join Date
    04-11-2005
    Location
    London
    Posts
    259

    Re: "Element not found" - Date and Time Picker (SP2)

    Ho hum. That would explain why it doesn't work, I guess. The Microsoft Forms 2.0 Object Library is present though - in Excel 2007 and 2010.

    Any suggestions for an alternative then? I like date/time pickers

  4. #4
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    Re: "Element not found" - Date and Time Picker (SP2)

    i used to use the calendar control for 2003/2007, but we have just moved to 2013 at work and that no longer supports that control. i have got to redo all my work again!
    Regards
    Sean

    Please add to my reputation if you think i helped
    (click on the star below the post)
    Mark threads as "Solved" if you have your answer
    (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code:
    [code] Your code here [code]
    Please supply a workbook containing example Data:
    It makes its easier to answer your problem & saves time!

  5. #5
    Forum Contributor
    Join Date
    04-11-2005
    Location
    London
    Posts
    259

    Re: "Element not found" - Date and Time Picker (SP2)

    So how did you redo it then Sean?

    Thanks
    Martin
    ps - I lived in Herne Bay from 1991 to 1995. Know the area well.

  6. #6
    Registered User
    Join Date
    06-17-2009
    Location
    Canada
    MS-Off Ver
    Office 2010
    Posts
    84

    Re: "Element not found" - Date and Time Picker (SP2)

    Are you able to post a sample workbook. I have solved the same issues in my workbooks, I checked my code and can not remember what I changed.
    I use date pickers in Office 2010 and 2013

  7. #7
    Forum Contributor
    Join Date
    04-11-2005
    Location
    London
    Posts
    259

    Re: "Element not found" - Date and Time Picker (SP2)

    Actually I was experimenting on a blank workbook with a blank form.

    However thanks to the various commentators above, I changed tack and started to search for a replacement Date & Time Picker. I found this -

    Close Excel
    2.Download MSCOMCT2.cab (it's a cabinet file which extracts into two useful files)
    3.Extract Both Files | the .inf file and the .ocx file
    4.Install | right-click the .inf file | hit "Install"
    5.Move .ocx file | Move from "C:\Windows\system32" to "C:\Windows\sysWOW64"
    6.Run CMD | Start Menu -> Search -> "CMD.exe" | right-click the icon | Select "Run as administrator"
    7.Register Active-X File | Type "regsvr32 c:\windows\sysWOW64\MSCOMCT2.ocx"
    8.Open Excel | Open VB Editor
    9.Activate Control | Tools->References | Select "Microsoft Windows Common Controls 2-6.0 (SP6)"
    10.Userform Controls | Select any userform in VB project | Tools->Additional Controls
    11.Select "Microsoft Monthview Control 6.0 (SP6)"
    12.Use 'DatePicker' control for VBA UserForm
    It works!

    Thanks to Stack Overflow for this solution.
    http://stackoverflow.com/questions/1...o-vba-userform

+ 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. [SOLVED] How to fill range with "Microsoft Date And Time Picker Control"
    By herukuncahyono in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2013, 11:47 PM
  2. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  3. Date and Time Picker has Red "X"
    By cabinetguy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-11-2011, 02:00 PM
  4. Date Picker and "Permanent" in Drop Down List
    By yocin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2010, 10:12 PM
  5. How to control "Date Time Picker ActiveX Control"
    By Jafery in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2005, 10: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