Hi all,

sometimes, execution pause without breaking points and can continue if F5
key pushed. could you tell me the reason?

Clara




--
thank you so much for your help

I only had one situation happen to me, which actually took place in Access.
There were no break points, nor was there a "Stop" command at the point
where VBA stopped running and took the user into VBA while testing the
program out, but it was pretty persistent that it happened at one particular
point in the code, and it only took place the first time around it was ran,
but yet, there was no error message or anything. Not even the typical
Continue, End, Debug, and Help error dialog box.

Since that time, we are no longer facing the issue. However, I'm not sure
if it was due to some update that had to be done or if there was some other
change that stopped it from happening again.

Are you finding a similar type finding or what sort of pattern are you
noticing when this takes place?

Does it happen only the first time it is ran since the file being opened?
Does it stop at a particular point every time, when it does happen?
Is it some other persistent pattern as to when this happens?

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

"clara" wrote in message
...
Hi all,

sometimes, execution pause without breaking points and can continue if F5
key pushed. could you tell me the reason?

Clara




--
thank you so much for your help

Hi Ronald,

The following are some points which I think is improtant to describe the
situation:
1. I made some change in code, but the change is very small
2. the 'stop' happened some times in the same place
3. there was a yellow stripe marking the code line and nothing
4. I have met similar cases sometimes in Excel VBA

thank you for your reply

Clara
--
thank you so much for your help


"Ronald Dodge" wrote:

I only had one situation happen to me, which actually took place in Access.
There were no break points, nor was there a "Stop" command at the point
where VBA stopped running and took the user into VBA while testing the
program out, but it was pretty persistent that it happened at one particular
point in the code, and it only took place the first time around it was ran,
but yet, there was no error message or anything. Not even the typical
Continue, End, Debug, and Help error dialog box.

Since that time, we are no longer facing the issue. However, I'm not sure
if it was due to some update that had to be done or if there was some other
change that stopped it from happening again.

Are you finding a similar type finding or what sort of pattern are you
noticing when this takes place?

Does it happen only the first time it is ran since the file being opened?
Does it stop at a particular point every time, when it does happen?
Is it some other persistent pattern as to when this happens?

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

"clara" wrote in message
...
Hi all,

sometimes, execution pause without breaking points and can continue if F5
key pushed. could you tell me the reason?

Clara




--
thank you so much for your help

I have a similar issue that started around the same time of the original post
(10/07). However, on my system it is not related to any one excel VBA code,
but most workbooks with code. The only change to my system have been the
normal MS Fix/Patch files that are pushes to our computers through MS Update.


Code runs fine, but the user has to continually click the CONTINUE button to
execute code. There is no consistency to the problem...sometimes code runs
without stopping, other times it stops every few seconds.

"clara" wrote:

Hi all,

sometimes, execution pause without breaking points and can continue if F5
key pushed. could you tell me the reason?

Clara




--
thank you so much for your help