Solved

breakpoints appear to have remained in vba

Posted on 2014-09-03
4
171 Views
Last Modified: 2014-09-03
I was testing some code and added breakpoints. I removed the breakpoints but its still stopping in the same places. maybe i have done something silly that i cannot spot?

I have a screen shot here where it stopped.

I tried saving and repair options but it still halts and waits.
ee-breakpoints.PNG
0
Comment
Question by:PeterBaileyUk
  • 2
  • 2
4 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 40300986
No, it's an age old problem in VBA ("Phantom Break points").

Open a code module, add a line of code (like a STOP).  Save and compile.   Then do a "Remove all break points", remove the stop, compile and save.  That usually gets rid of the problem.

Jim.
0
 
LVL 57
ID: 40300994
You can also cut and paste all the code in a module and/or do a /decompile.

Anything that forces VBA to change the state of the module and be forced to do a recompile.

Jim.
0
 

Author Comment

by:PeterBaileyUk
ID: 40301026
Success, well i never had that before.
0
 

Author Closing Comment

by:PeterBaileyUk
ID: 40301027
thank you.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question