|
To complete Progress Bar indicator level to 100%
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 |
To complete Progress Bar indicator level to 100%
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 |
To complete Progress Bar indicator level to 100%
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 |
To complete Progress Bar indicator level to 100%
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 |
To complete Progress Bar indicator level to 100%
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 |
| All times are GMT +1. The time now is 04:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com