+ Reply to Thread
Results 1 to 9 of 9

fixing run time error 13 not show userform

  1. #1
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    fixing run time error 13 not show userform

    hello
    i got this calendar from the internet but when i run to show userform it gives me run time error13 i need help to fixing this error because i would specialize some days of occasions for my country
    thanks advance
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: fixing run time error 13 not show userform

    image 1: result after running the initialization code.
    image 2: breakpoints set and error trapping spec shown.

    do you see what I did? I got no error.
    Attached Images Attached Images

  3. #3
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: fixing run time error 13 not show userform

    hi adam sorry about delaying respond you i did as your image 2 the error highlights in this line
    HTML Code: 
    i wonder how works for you, does version Microsoft office relate ?

  4. #4
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: fixing run time error 13 not show userform

    what does the error SAY? not just number 13. what's the *message*?? *description given*?

    it's possible that your system does not like the format of the date you are using. but then again, the weekday() function returns a variant type. I don't think that would matter here, however you might try this:
    Please Login or Register  to view this content.
    or:
    Please Login or Register  to view this content.
    and yes, ms office products, for lack of a better term, are ""terrible"" from version to version. inconsistencies are never looked at by the MS team and it's been that way for 20 years at least.

    https://docs.microsoft.com/en-us/off...ekday-function

  5. #5
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: fixing run time error 13 not show userform

    the error is type mismatch and i try your suggestion the problem still continues

  6. #6
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: fixing run time error 13 not show userform

    more than likely that means that the combination of all of this is causing issues:
    Please Login or Register  to view this content.
    a type mismatch error means that you are trying to put a data type into a variable that has been declared another data type.

  7. #7
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: fixing run time error 13 not show userform

    i no know if there is solution but i think the problem because the language of Microsoft office in my case is Arabic have ever occurred some errors codes relating months or years

  8. #8
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: fixing run time error 13 not show userform

    Quote Originally Posted by ABDELFATTA View Post
    but i think the problem because the language of Microsoft office in my case is Arabic have ever occurred some errors codes relating months or years
    what does the Arabic language have to do with this issue? I would seriously doubt that is the problem. Can you post a screenshot of the code in the VBA window for us? the code is not actually written in arabic, is it? I just worked for a woman in Slovenia and all of her code was written in English, even though everything she created in the interface was in the Slovenian language.

    but you should know too, that I don't believe Microsoft has taken into account all of the quirks associated with selling office products to every country in the world. They probably can't. There's too many possibilities, and they're too busy trying to meet NYC's revenue targets for every earnings quarter.

  9. #9
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: fixing run time error 13 not show userform

    this is what shows me when i run userform
    Attachment 693117
    Attachment 693118

+ 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. Run Time Error '5': Invalid Procedure call or argument in Userform.show
    By nandhavnk in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-03-2019, 11:44 AM
  2. Show Userform error
    By henryBukowski in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-06-2016, 10:00 AM
  3. [SOLVED] Run-time error 424 when trying to show userform
    By cole.young in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-25-2014, 11:35 AM
  4. Need help fixing macros due to Run-Time error 1004 Sort Reference is Not Valid
    By travisg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2013, 12:13 AM
  5. UserForm as Add-In (Getting Error 9 on .show)
    By nalfin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-02-2009, 06:08 AM
  6. [SOLVED] Run time error on Userform Show
    By DonF in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-23-2005, 06:00 PM

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