Progress Bar form window goes white
 

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

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