Link to home
Create AccountLog in
Avatar of corhaveman
corhavemanFlag for Netherlands

asked on

vba code stops for no reason

hi experts,

You probably recognize the problem: vba code stops for no reason: no error message and after pressing F5 the code continues normal. I sometimes have this problem. Sometimes it helps to re-type the code-line and delete the old one. Does anyone know what causes this problem? And is there a specific solution for this 'bug'?
SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
As Scott said, it's a code break that remains in affect.  What I do however is simply do a clear all breaks points, then right before the line it stops on, just add a blank line and save the module.  I don't bother to cut and paste anything.

That always cures it.

Jim.
Avatar of corhaveman

ASKER

Thanks experts. This should solve this annoying problem.
I'm sorry Jim: the points are already given ;-(
This issue was prominent in Excel 2003.  The only way to fix it was to reboot your PC.  

Scott C
<<I'm sorry Jim: the points are already given ;-( >>

 Not a problem.

<<This issue was prominent in Excel 2003.  The only way to fix it was to reboot your PC.>>

 Don't ever remember having to reboot, but then I work mostly in Access (about 99%).  VBA I think would be the same regardless, but it may have had to do with the hookup of VBA and the specific product it was tied to.

Jim.
"This issue was prominent in Excel 2003":
amazing MS is not capable of resolving this issue