View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Coleman John Coleman is offline
external usenet poster
 
Posts: 274
Default Continuous Loop

You can try putting a DoEvents statement in the loop. This might work
if the loop depends on an event which for some reason isn't registering
when the loop is running.

Just a stab in the dark (maybe one of the gurus can make a stab in the
light)

-John Coleman

Freddy wrote:
I have a working Visual Basic Module that successfully runs standalone. Now,
I am trying to invoke/call it from a userform. However, it runs then loops
instead of stopping. I have stepped through the code using F8 and it does not
loop. It appears that things have to "slow down" for it to work. Any
solutions?