Incremental Progess Indicator

[Guest]

Hi,
I need to build a progress indicator for the following loop:
_______________________________
For i = 0 To TextBox1.Value

‘some code

PctDone = i / TextBox_cnt.Value

Next i
______________________________

TexBox1 is an UserForm input, so it is variable. Instead of continuously
updating progress indicator, I’d like to show something at each +5 %
completed for example. How can this be coded?

Thank you.

 

[Guest]

Check this out...

http://www.cpearson.com/excel/Progress.htm