+ Reply to Thread
Results 1 to 6 of 6

Catastrophic Failure Error

  1. #1
    Registered User
    Join Date
    09-05-2019
    Location
    Ohio
    MS-Off Ver
    Office 365
    Posts
    3

    Catastrophic Failure Error

    I have made a handful of data entry user forms before. But this error is a first for me. If you have any advice please let me know.

    Excel Error.png
    Attached Files Attached Files

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Catastrophic Failure Error

    Try saving your workbook an .xlsb see if that resolves the error.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    09-05-2019
    Location
    Ohio
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Catastrophic Failure Error

    Thanks JBeaucaire, but I still get the same error box.

  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: Catastrophic Failure Error

    It looks to me like the file is corrupt? I can't find a Sheet1 (even though it is listed in the VBA Project), and there are 2 "ThisWorkbook" objects if you look in the VBA editor. I'd suggest making a new workbook, and copying the objects and code that you need then see if it works.
    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.

  5. #5
    Registered User
    Join Date
    09-05-2019
    Location
    Ohio
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Catastrophic Failure Error

    Thank you Arkadi, that fixed the problem!

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

    Re: Catastrophic Failure Error

    Glad to hear it

    Thanks for the rep.

+ 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. System Error &H8000FFF (-247418113). Catastrophic failure
    By Gus333 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-22-2019, 07:26 PM
  2. Automation Error: Catastrophic failure
    By NYCoder87 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-20-2016, 08:04 PM
  3. System Error &H8000FFFF (-2147418113). Catastrophic failure
    By questionguy in forum Excel General
    Replies: 1
    Last Post: 08-27-2012, 06:14 PM
  4. Path/file error and catastrophic failure after inactivitiy
    By nomorefun in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-25-2012, 11:40 AM
  5. Userform.show = Catastrophic Failure
    By mark.mba in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-15-2009, 08:48 AM
  6. catastrophic failure
    By Harikarishna in forum Excel General
    Replies: 0
    Last Post: 07-07-2006, 06:55 AM
  7. System Error &H8000FFFF (-2147418113). Catastrophic Failure
    By poppy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-30-2005, 08:40 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