ProgressBar [RESOLVED]

[doofusboy]

Know how display and show a ProgressBar working, but want it to show while other tasks are being done.

Specifically, am reading data from a Notepad file and writing parsed info to an Excel spreadsheet. How do I show the ProgressBar functioning while the reading and writing is going on?

[peet]

depends a bit on how your code is built up....

'start loop
'read from file
'update progress
'doevents
'write to file
'update progress
'doevents
'end loop

something along those lines maybe

[doofusboy]

Aha.......so you're saying it depends on where my

ProgressBar1.Value = i
DoEvents


statements are made in my code?


And do I need to include a "Do Events" every time I update the ProgressBar1.Value?

[peet]

you have to "feel your way" when it comes to how often you want to do the doevents

in order for the pb to view its updates, u will probably need it for each loop...

[peet]

the doevents will slow down your code though

[Joacim Andersson]

You can probably just use a ProgressBar1.Refresh call instead of calling DoEvents. But the prograssbar must somehow get processor time to redraw itself.

[doofusboy]

Issue resolved by updating ProgressBar1.Value during other processing .....and ProgressBar1.Refresh was just the ticket! ....works like a charm

Thanks to all who responded.