+ Reply to Thread
Results 1 to 5 of 5

Object not found Error 424

  1. 06-16-2021, 04:46 PM #1
    Magmarinita
    Magmarinita is offline
    Registered User
    Join Date
    05-12-2021
    Location
    México
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (16.0.13530.20054)
    Posts
    17

    Exclamation Object not found Error 424

    Dear experts:

    I was working on a userform that is showed when a button is clicked (Page "Summary", "Perform QA" green button). It was working fine until... it was not.
    I have recreated the object from scratch, changed the name, but I still get this error:
    Error.png
    Debug.png

    Could you please advice? Am I doing something wrong? (Sorry to disturb, I'm just learning about this and I'm having a heart attack right now jeje)

    Any advice for improvement will be welcome!

    Workbook attached, just in case!

    Thanks in advance!
    Last edited by Magmarinita; 06-16-2021 at 08:27 PM.
    Reply With QuoteRegister To Reply
  2. 06-16-2021, 06:06 PM #2
    dangelor
    dangelor is offline
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Object not found Error 424

    You may have a typo in this bit of code... 
    Please Login or Register  to view this content.
    The code actually breaks on the highlighted line. Try adding a 0 between the Q and the 5. ...QATBCQ05...
    Reply With QuoteRegister To Reply
  3. 06-16-2021, 06:29 PM #3
    Tinbendr
    Tinbendr is offline
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Object not found Error 424

    You have to F8 through the code because the editor will always start to the beginning of the offending object code.

    You have 
    Please Login or Register  to view this content.
    You're missing the 0 from QATBCQ5.Value = "".

    Changed to QATBCQ05.Value = "" and no error.
    David
    (*) Reputation points appreciated.
    Reply With QuoteRegister To Reply
  4. 06-16-2021, 08:09 PM #4
    Magmarinita
    Magmarinita is offline
    Registered User
    Join Date
    05-12-2021
    Location
    México
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (16.0.13530.20054)
    Posts
    17

    Re: Object not found Error 424

    Thank you so much, Dangelor! It is as you said! Could you please tell me how did you catch that that line was the issue? Is there a way to enable a verbose debug or something that may point me to the right place instead of the beginning of the offending object code?
    Reply With QuoteRegister To Reply
  5. 06-16-2021, 08:13 PM #5
    dangelor
    dangelor is offline
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Object not found Error 424

    In the VB Editor, go to Tools>Options...>General>Error Trapping> select Break on All Errors.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Getting error An object could not be found
    By fabian_76 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-16-2018, 03:09 PM
  2. Web browser Error - Object Not Found
    By Quivolt in forum Microsoft Windows Help
    Replies: 11
    Last Post: 04-24-2018, 01:39 PM
  3. [SOLVED] Object not found error
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-03-2013, 12:45 PM
  4. [SOLVED] object not found error
    By Willardio in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 12-26-2012, 11:40 AM
  5. Object not found error
    By Viscount_Grey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-23-2011, 12:15 PM
  6. run time error 424 object not found
    By GingerJah in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-12-2010, 06:52 AM
  7. Replace object causes an error if search text not found
    By Scott in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2006, 03:15 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1