Excel VBA error:  Microsoft Excel Has Stopped Working

    Question by:
    On

    Topics:

    I am using Microsoft Excel 2010 and have a rather complex user form that has 6 rows of 30 controls each on one tab of a MultiPage control.  There are several other Tabs/Pages in the form, but this particular Tab/Page oftentimes throws the error "Microsoft Excel has stopped working."  This problem does not occur every time the Form is used, but it does occur frequently enough to be frustrating.  

    I have perused the Microsoft KB article 319832, "INFO: Error or Unexpected Behavior with Office Automation When You Use Early Binding in Visual Basic" but I still get the message even after ensuring that Option Explicit is in place.  I have also set VBA to "Break on all errors" but this error does not cause any offending line to be highlighted.

    Once the issue does occur, exporting then deleting then importing the user form seems to correct the problem -- for a while, but not permanently.

    Any ideas on what might be causing it or what steps I can take to find the offending code?  
    Good Question?
    0

    Featured Post

    Course: Foundations of Front-End Development

    Jump-start a lucrative career in front-end web development, with zero previous coding experience required. This course covers the basic programming concepts and languages required for creating engaging websites from scratch.

    Top Expert Contributor

    Essential articles and videos from the Experts

    I've recently been in need of an Excel macro that could add a letter before the text on multiple cells in an Excel document. My English is as it is, so I will try explain what it does diffrently. If you have an excel document with 2000 rows an…
    Sometimes we don't want to show zeros in our Excel spreadsheets. This is sometimes most evident in our charts. Look at the chart below, all the zero values are visible. I think that all will agree with the fact that zero values are not looking nice …
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

    More valuable questions with Expert answers

    Question: Hello I have created a custom menu using CustomUI for Excel. In the menu I have a menu item that opens an excel template. The macro saves the file with the nomenclature that MUST be used and when the macro ends, the user can edit , review,...

    Answer: Hi. If I have understood correctly the core issue is that you want your custom tab to stay selected when the template workbook opens. Yes ? You can do this (and I have done) but what you need to do is to store the ribbon ID of your custom...

    Question: I would like to enter 10000 in cell 'D4' and it automatically do a calculation. Example: In cell 'D4' enter 10000 and when I hit enter it returns '5' (calculation is 10000 / 2000) so, no matter what number I enter in 'D4' it automatically...

    Answer: Please follow these steps..... Right click on the Sheet Tab --> View Code --> Paste the following code into the opened code window --> Close VB Editor --> Save your workbook as Macro-Enabled Workbook. (CODE) To view the code in the...

    Question: Dear Experts: I would like to apply table styles to several current rages of the current worksheet using VBA The requirements in detail Requirements 1. Go To the Term 'OrderNo Get the current range (Ctrl+Shift+Space Bar) Apply the...

    Answer: Hi, pls try (CODE)Regards

    Question: I have an Excel with ODBC connection to our SQL database. I have to update this Excel every day and send it. I want to automate this process in a bat file. Is it possible to update an Excel with ODBC via a command line / parameters? I...

    Answer: >>Is it possible to update an Excel with ODBC via a command line / parameters? yes, that's possible. but what stuffs are you going to "update" in your excel? to automate the process, you can write a vbscript/macro and then let relevant scripts...

    201601-LO-Qu-076

    Extend your technology team with the Experts Exchange community.

    — trusted by —

    Who answers my questions?Our community has technology experts around the world.

    Subodh Tiwari (Neeraj)

    728

    Solutions

    Expert in:

    • MS Excel
    • VBA
    • MS Office
    • Visual Basic Classic
    • MS Applications

    Rgonzo1971

    1

    Articles

    2,556

    Solutions

    Expert in:

    • MS Excel
    • MS Office
    • VBA
    • Visual Basic Classic
    • MS Access

    Qlemo

    8

    Articles

    6,411

    Solutions

    Expert in:

    • MS SQL Server
    • Powershell
    • VPN
    • MS DOS
    • MS SQL Server 2008

    Ejgil Hedegaard

    431

    Solutions

    Expert in:

    • MS Excel
    • VBA
    • MS Office
    • Spreadsheets
    • VB Script

    Ryan Chong

    5,426

    Solutions

    Expert in:

    • Visual Basic Classic
    • ASP
    • MS Access
    • JavaScript
    • ASP.NET

    Roy_Cox

    306

    Solutions

    Expert in:

    • MS Excel
    • VBA
    • MS Office
    • VB Script
    • Visual Basic Classic

    Martin Liss

    16

    Articles

    2,254

    Solutions

    Expert in:

    • MS Excel
    • Visual Basic Classic
    • MS Office
    • VB Script
    • VBA

    tomfarrar

    4

    Articles

    62

    Solutions

    Expert in:

    • MS Excel

    Rob Henson

    1,444

    Solutions

    Expert in:

    • MS Excel
    • MS Office
    • Spreadsheets
    • MS Applications
    • VB Script

    RELATED TOPICS view all topics

    1. MS Office
      (56,483)
    2. Visual Basic Classic
      (163,312)
    3. VB Script
      (35,948)
    4. MS Applications
      (43,069)
    5. Spreadsheets
      (5,883)
    6. MS Access
      (214,540)
    7. MS Word
      (26,703)
    8. VBA
      (4,337)
    9. Programming-Other
      (51,578)
    10. Visual Basic.NET
      (91,308)