Results 1 to 2 of 2

Drop down Calendar: Excel 2010 DTPicker issue

Threaded View

contaminated Drop down Calendar: Excel... 11-06-2012, 04:43 AM
contaminated Re: Drop down Calendar: Excel... 11-06-2012, 09:52 AM
  1. #1
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Drop down Calendar: Excel 2010 DTPicker issue

    Hi all

    I have a userform which have two DTPicker Controls. It worked like a charm, but recently I formatted my laptop, and now when press a button to open userform, it returns error msg "Run Time Error -2147221005 (800401f3) Invalid class string"

    I figured out why this happens. This happens on UserForm Initialization at strings:
        Set StartDropCalendar = Me.Controls.Add("MSCOMCT2.DTPicker.2", "")
        Set EndDropCalendar = Me.Controls.Add("MSCOMCT2.DTPicker.2", "")
    Because I had no MSCOMCT2 on system by default, I downloaded RAR folder, and placed it to C:\windows\sysWOW64 because I installed 64 bit Windows. Then run cmd.exe as administrator, and typed command

    regsvr32 C:\Windows\SysWOW64\MSCOMCT2.OCX
    The command registered MSCOMCT2.OCX. but when I tried ti open userform I was getting the same message. I rebooted PC, but got the same error...
    Then I read from somewhere that I must run regsvr32 placed exactly in sywWOW64 folder, so I typed this command on cmd.exe

    C:\WINDOWS\sysWOW64\regsvr32.exe C:\WINDOWS\sysWOW64\MSCOMCT2.OCX
    And after hitting Enter key I got RegSvr32 Error message: C:\WINDOWS\sysWOW64\MSCOMCT2.OCX failed to load

    So, what's a problem?! In addition I must tell that I cannot change desktop wallpaper. I get a message This picture annnot be set as wallpaper. Internal Error occurred IMO I must repair my Windows...

    PS: I know, I can use DTPicker alternatives, but I want to solve this issue...

    Thx in advance
    Last edited by contaminated; 11-06-2012 at 04:47 AM.
    Люди, питающие благие намерения, как раз и становятся чудовищами.

    Regards, ?Born in USSR?
    Vusal M Dadashev

    Baku, Azerbaijan

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