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