Progress Bar form window goes white

[philwongnz]

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

 

[Chip Pearson]

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"
in message
news[email protected]...