+ Reply to Thread
Results 1 to 5 of 5

Run Time Error 13

Hybrid View

  1. #1
    Registered User
    Join Date
    02-25-2014
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    2

    Run Time Error 13

    I am quite new to VBA and I called up this error with "lRow = GetSheetRow(lblID.Caption)" Aynone know the reason?

    Thanks

    Steph
    Attached Files Attached Files

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Run Time Error 13

    When does the error come up?
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Registered User
    Join Date
    02-25-2014
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Run Time Error 13

    when I press "F5" when I want to run the userform

  4. #4
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Run Time Error 13

    stephanization,

    I'm afraid I'm not very familiar with listboxes, but it seems to me there are un-numbered lines that get listed in there, i only get the error when I pick a line with no number in the first column... too much in this one I'm not familiar with, sorry I can't be more use.

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: Run Time Error 13

    I can only recreate the problem when pressing the Raised RFI No button and I think the problem is because the listbox isn't populated properly and/or it's change event is being called.
    If posting code please use code tags, see here.

+ 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. Cannot Publish Excel Pivot Chart - Run Time Error
    By crisb184 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2013, 07:04 AM
  2. [SOLVED] Error " Run-time error '1004': application defined or object defined error
    By lengwer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2013, 07:26 AM
  3. Replies: 7
    Last Post: 05-15-2013, 09:02 AM
  4. run-time error ;2147023179 (800706b5) time automation error interface unknown
    By karthik72 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-02-2012, 09:31 AM
  5. Error "run-time Error '1004': General Odbc Error
    By D4WNO77 in forum Access Tables & Databases
    Replies: 2
    Last Post: 07-16-2012, 09:55 AM

Tags for this Thread

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