+ Reply to Thread
Results 1 to 5 of 5

Unable to Open User Form in French Excel

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

    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 Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    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 Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    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.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  4. #4
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    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

  5. #5
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Unable to Open User Form in French Excel

    Changez la feference á MSCOMCT.OCX, il faut le cerceher dans C:|windows\System32 ou System64
    C'est une modification fait par Microsoft.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ 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] Excel 2013 user form unable to set label text color in VBA code
    By silveredge8181 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-09-2016, 04:31 PM
  2. [SOLVED] I create a user form but unable to edit saved data
    By manissinha5 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-06-2016, 01:54 PM
  3. Unable to edit sheet after hiding User Form
    By seatbelts in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-23-2014, 09:16 AM
  4. Unable to transfer data from user form to spread sheet
    By katieshields in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-19-2014, 05:43 AM
  5. [SOLVED] Excel vba user form- open directly to user form not worksheet
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 04-24-2013, 05:07 PM
  6. Create the user form shortcut without open Excel workbook. Does it possible?
    By pyol17 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2012, 11:47 PM
  7. Run time error 13 Unable to call User Form
    By Spagbog in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-13-2011, 09:06 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