Thread: DoEvents
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default DoEvents

Post the macro, or preferably a shorten ed version that hangs.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Arne Hegefors" wrote in message
...
Hi! I have a macro that keeps hanging. The macro is basically a very long
loop so I am not surprised. I am told that you can use something called
DoEvents in combo with GetQueueStatus API function. However I have no idea
how to use that stuff and nothing comes up in the vba help. If anyone can
quickly describe how to use or knows a good webpage I would be very

grateful.
I have tried to goole it but without any realy success. Many thanks in
advance!