+ Reply to Thread
Results 1 to 4 of 4

Unable to Open User Form in French Excel

  1. #1
    Registered User
    Join Date
    05-05-2017
    Location
    Mauritius
    MS-Off Ver
    2010
    Posts
    19

    Unable to Open User Form in French Excel

    Dear Team,

    I have developed forms in english excel and now opening in the french environment and having the below errors;

    1. Error due to DatePicker1 but after pressing Ok this box is not visible
    Capture1.PNG

    2. Some "bibliotheque" related error does not allow me proceed with macro

    Its really urgent kindly help
    Capture.PNG

    Regards

  2. #2
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    3,202

    Re: Unable to Open User Form in French Excel

    Hi NikhilDixit,

    In this case your 'Object or Library Not Found' compile error usually means a VBA library reference is not checked.

    In Visual Basic to to:
    Tools > References > Check 'Microsoft Forms 2.0 Object Library'

    For additional information see: https://stackoverflow.com/questions/...-vba-functions

    Lewis

  3. #3
    Forum Expert xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    3,575

    Re: Unable to Open User Form in French Excel

    Hi,

    The Date picker control is not available to all versions of Office/Windows and it appears that it is not on your French machine. You will most likely therefore have a MISSING: reference to the Windows Common controls, due to the first problem, which is what causes the second problem. I suggest you use an alternative such as a calendar user form that will not have those issues.
    Please remember to mark your thread 'Solved' when appropriate.

  4. #4
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    3,202

    Re: Unable to Open User Form in French Excel

    Excellent 'Date Picker' point xlnitwit.

    NikhilDixit,

    If your problem is caused by 'Date Picker' see the following thread for additional information:
    DTPicker is in MSCOMCT2.OCX (in SYSTEM32, or SYSTEM, or SysWOW64 folder)
    Correcting MSCOMCT2.OCX not available errors: http://www.excelforum.com/excel-prog...ry-errors.html

    The 'Date Picker' I use is in post #3 of the following thread: http://www.excelforum.com/excel-gene...-combobox.html

    Lewis

+ 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