473,385 Members | 1,309 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

VBA code randomly stopping

Seth Schrock
2,965 Expert 2GB
I have some code that I'm trying to run in Excel 2013 VBA. Periodically when I try to run my code, I get a message saying "Code execution has been interrupted". If I click debug and then F8 the rest of the way through it, everything runs fine. I can also click Continue and it works. It almost never stops at the same place. I've never had this happen in Access VBA so I'm a little lost as to why it keeps doing this.
May 13 '13 #1
1 4480
Seth Schrock
2,965 Expert 2GB
After continuing to google this problem, I found this:

"After some googling I've found better (quicker) solution: just end macro, switch to the VBE and hit Ctrl+Break. After that the code execution doesn't break."
Link: http://social.msdn.microsoft.com/Forums/en-US/...
May 13 '13 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: John Pastrovick | last post by:
When writing an HTML table after a PHP database query very occasionally (1 out of ten times -- same code) the HTML page is truncated and cells/or full final rows of table are missing. Looking at...
5
by: siliconmike | last post by:
On many websites they have a blurred image with a code which you're supposed to reenter in a text box to validate your form submission. How do I implement such a thing using php? Apart from...
1
by: stewert gallington | last post by:
Im running some pretty straight forward code. Mainly database access (SQL7) doing inserts and sometimes when the script runs it halts the IIS service dead in its tracks. Before the page can even...
1
by: DS | last post by:
What in this code is stopping me from adding new records? Private Sub ListProd_Click() On Error GoTo GotError DoCmd.GoToControl "" Me!.Form.AllowAdditions = True DoCmd.GoToRecord , , acNewRec...
46
by: Profetas | last post by:
Hi, I know that this is off topic. but I didn't know where to post. Do you comment your source code while coding or after coding. for example: you write a procedure and after it is...
15
by: ben | last post by:
this programme from sedgewick's 'algorithms in c parts 1-4' "is a sample client program that ... uses a symbol table to find the distinct values in a sequence of keys (randomly generated or read...
9
by: AndersBj | last post by:
Hi all, I have a web application that uses State Server for session handling. The web application randomly loses all session variables. The sessions are not always lost, sometimes I can use the...
3
by: ohnoonho | last post by:
Hello, I posted this in the C# group but thought maybe the better place would be here since it is happening with website projects so please forgive any cross posting. In my website projects I...
0
by: eldamiani | last post by:
Ineed a help. I want to ask, how I can do dialog box window which is a normal form, but causes stopping the code execution in form which call out this dialog box. I have ...
3
by: banderson | last post by:
Hello, I am not sure why this code is not working. I have a pop-form to edit a drop down list that is found in a control (combo box) on 8 different forms. On this pop-up form, I have added a...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.