LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default VBA Hangs

Hi, I've noticed that whenever I write anything that requires significant CPU
resource in VBA (either through excel or word) the program hangs if I choose
to invoke another program while it runs in the background. As an example,
create a simple form with a progress bar and then initiate a loop which
counts from 1 to 10,000,000 and update the progress bar based upon the value
of the loop.

Once the program starts running, move down to the task bar (I'm using XP
with all the latest patches) and you'll find that excel and your program code
stops responding and doesn't come back unless you force a close of excel.
The same applies if your screen saver kicks in.

This is quite frustrating for any intensive processing that goes on and I'd
appreciate other people's comments and fixes that you may be aware of.

Thanks in advance for replies.

Peter
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel hangs up. bc Excel Discussion (Misc queries) 0 February 28th 06 06:30 PM
Excel Hangs Linda Excel Discussion (Misc queries) 2 October 4th 05 04:36 PM
DDE Startup Hangs amac Excel Programming 1 November 10th 04 02:58 PM
DDE startup Hangs amac Excel Programming 0 November 10th 04 02:37 PM
ddeinitiate Hangs Ann Excel Programming 0 September 7th 04 03:17 PM


All times are GMT +1. The time now is 01:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"