Consulting

Results 1 to 5 of 5

Thread: Run-Time Error 13

  1. #1
    VBAX Newbie
    Joined
    Jul 2019
    Posts
    1
    Location

    Run-Time Error 13

    Hi All,

    I am getting "Run-Time error 13" error when i click on "Open Form" button. Any one can help me how to resolve the issue
    Attached Files Attached Files

  2. #2
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location
    At a guess, change the XXXXXXXXXXXXX row to column A

    'find last data row from database
        iRow = ws.Cells(Rows.Count, 1).End(xlUp).Row      ' Column A
    
    '    iRow = ws.Cells(Rows.Count, 3).End(xlUp).Row XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
    
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  3. #3
    VBAX Mentor
    Joined
    Apr 2009
    Location
    Kingsbury
    Posts
    423
    Location
    Cannot see vba code Whats the password ?????
    If we can't see the code how do you expect it to get solved ?

  4. #4
    Just hack the password It's easy.

    Under 'userform_activate' you have:
    Me.txtSlNo2.Value = ws.Cells(iRow, 1).Value + 1
    I guess you want this instead.
    Me.txtSlNo2.Value = ws.Cells(iRow, 1 + 1).Value
    Changing this value allows the userform to open, and doesn't result in 'Run-Time Error 13'

  5. #5
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location
    Quote Originally Posted by ashleyuk1984 View Post
    Just hack the password It's easy.
    We don't talk about hacking and cracking passwords here

    http://www.vbaexpress.com/forum/faq.php?faq=psting_faq_item#faq_hack_faq_item

    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •