- For individual users
- Instant access to solutions
- Ask your tech questions
- Start your 30-day Free Trial
Main Topics
Browse All TopicsQuestion
Excel VBA error: Microsoft Excel Has Stopped Working
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?
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?
This question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Subscribe now for full access to Experts Exchange and get
Instant Access to this Solution
- Plus...
- 30 Day FREE access, no risk, no obligation
- Collaborate with the world's top tech experts
- Unlimited access to our exclusive solution database
- Never be left without tech help again
Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.
Your Complete Technology Resource
900+ topic areas (and counting)
Featured Video Tutorials
More Technology Tutorials
Featured Articles
WARNING: 5 Reasons why you should NEVER fix a computer for free.
It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul.
We love the accolades. We love to be seen as the digital white knight who fixed the server, the computer, the email, and anything else that life depends on.
We love it so much, we sometimes make horrible decisions. Sometimes, we work "FOR FREE."
SCCM OSD Basic Troubleshooting
SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispersed nature of the blog posts that deal with some of these issues. This article will help SCCM OSD newbies with some of these issues.
Integrating SCCM and MDT 2008.
For our deployments, we always install MDT 2008 on our SCCM server and select Configure ConfigMgr Integration from the MDT area on the start menu. This gives us:
- Templated task sequences we can import into SCCM
- Additional TS Variables for use in our task sequences
- Additional options and flexibility around computer backup...
Get full access to the help you need.
30-day free trial. Register in 60 seconds.
The Latest Technology News and Tips
EE Tech News Blog
Bringing you the latest in technology
| Congressman Proposes Bill to Ban... | 11/28/12 |
| Death to Internet Anonymity: Google... | 11/27/12 |
| TEDx San Luis Obispo | 11/20/12 |
| SharePoint 2010 No-Code Solutions... | 11/19/12 |
| Keeping Your Passwords And Your Win... | 11/15/12 |
| Fun and Games with Hackers: How to... | 11/15/12 |
EE Tech News Podcasts
Listen while you work
New Solutions Everyday
Because of our active community of experts, on average new questions receive their first comment in under 30 minutes.
Top MS Excel Questions
- Establish connection to Oracl…520 Views
- Outlook 2010 - Can't at…318 Views
- How Do I Pre-populate a W…295 Views
- How do convert microsoft e…243 Views
- Unable to scroll in Excel and …199 Views
- excel 2010 on Windows …154 Views
- Excel 2010 Create New P…141 Views
- Excel Macro to Clear Memory136 Views
- Microsoft Great Plains questi…128 Views
- Excel VBA - formular1c1 …127 Views
- CreateObject("EXCEL.AP…2,193 Views
- IF(ISERROR(VLOOKUP.…1,351 Views
- Excel "IF" formula change …1,196 Views
- Formatting Charts with Micro…1,006 Views
- stdole32.tlb error in Excel …1,003 Views
- Count Distinct/Unique Value…873 Views
- Error: Cannot Empty Clipbo…866 Views
- If Item exists in a collection in…850 Views
- the real difference between i…835 Views
- OLE Error 800A03EC813 Views
Hear What our Users are Saying
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
3 Ways to Join
Business Accounts
- Perfect for organizations
- Multiple users
- Save over 36%
- Create a Business Account
Answer for Membership
- Earn free access
- Showcase your knowledge
- No credit card required
- Sign Up to Answer