To complete Progress Bar indicator level to 100% once.

Assume my total Rows are 5000.
While going through each rows counting increase by 1 for displaying
indicator level.
If it reaches 100 it starts again from 1 to display until it completes
5000.

But i don't want to display it again-n-again. Instead to finish it
showing once.
My maths is very poor so i m unable to do the calculation to make it
5000 = 100.

So plz help to complete this indicator level to display 100%
accordingly on completing the total rows


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=471013

Update your progress counter by the ratio of total records to 100 each time.

So with 5000 records only update 5000/100 = every 50 records.

One way of applying this is to use the modulus function

If recC Mod 50 then UpdateProgress

where recC = current record count
every 50 records the UpdateProgress action will be triggered.

--
Cheers
Nigel



"ilyaskazi" wrote
in message ...

To complete Progress Bar indicator level to 100% once.

Assume my total Rows are 5000.
While going through each rows counting increase by 1 for displaying
indicator level.
If it reaches 100 it starts again from 1 to display until it completes
5000.

But i don't want to display it again-n-again. Instead to finish it
showing once.
My maths is very poor so i m unable to do the calculation to make it
5000 = 100.

So plz help to complete this indicator level to display 100%
accordingly on completing the total rows


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile:
http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=471013

Sorry should have read ......

If recC Mod 50 = 0 then UpdateProgress

--
Cheers
Nigel



"Nigel" wrote in message
...
Update your progress counter by the ratio of total records to 100 each
time.

So with 5000 records only update 5000/100 = every 50 records.

One way of applying this is to use the modulus function

If recC Mod 50 then UpdateProgress

where recC = current record count
every 50 records the UpdateProgress action will be triggered.

--
Cheers
Nigel



"ilyaskazi" wrote
in message ...

To complete Progress Bar indicator level to 100% once.

Assume my total Rows are 5000.
While going through each rows counting increase by 1 for displaying
indicator level.
If it reaches 100 it starts again from 1 to display until it completes
5000.

But i don't want to display it again-n-again. Instead to finish it
showing once.
My maths is very poor so i m unable to do the calculation to make it
5000 = 100.

So plz help to complete this indicator level to display 100%
accordingly on completing the total rows


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile:
http://www.excelforum.com/member.php...o&userid=23969
View this thread:
http://www.excelforum.com/showthread...hreadid=471013

Thank you nigel

Another problem:
----------------------
Though my workbook is invisible, i want to show progress bar on
userform for saving file (i.e to update my workbook).


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=471013

It is solved here...

http://www.ozgrid.com/forum/showthread.php?t=4107

--
ilyaskaz
-----------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...fo&userid=2396
View this thread: http://www.excelforum.com/showthread.php?threadid=47101