View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Progress Bar form window goes white

Try putting a form Repaint method each time you update the status
bar.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"philwongnz"
wrote
in message
...

Hi there,

I am currently trying to follow the progress bar instructions
from the
j-walk.com website. However I am struggling to understand the
reason(s)
why my progress bar's form window goes white.

The funny thing is that when I insert a breakpoint on the line
where
the percentage gets updated, the form window shows up as
intended.
Pressing F5 again to run through my loop, the percentage gets
updated
as intended.

So i was wonderin whether my computer doesn't have enough
memory to
update the progress bar's form window while my macro is
running.

Thanks

Phil


--
philwongnz
------------------------------------------------------------------------
philwongnz's Profile:
http://www.excelforum.com/member.php...o&userid=26283
View this thread:
http://www.excelforum.com/showthread...hreadid=514188