I have a need to utilize a progress indicator which is time based.
Converting ascii "text" files to spreadsheets takes appx 5 min per
file. The conversion process can be for 1 or more files (up to 5). At
start time the number of files is determined. If processing 1 file
only the run time = 5 min, if 2 files run time = 10 min, etc. I would
like to display a progress indicator utilizing the system clock to
reflect the time left.

I have a UserForm "fmProgress" which has 2 "stacked" labels wiith
different colors.... That's as far as I can go! I need help with
writing code to make the top should grow (left to right) to cover the
bottom as a way to reflect the progress. I am also in the dark when
it comes to working with the system clock and using it to increment the
growth of the top label. If you have example code constructed (or
could construct same) I would greatly appreciate it!

I know that some of you have "been there, done that", hence I ask for
your assistance. Thank you very much.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Did you try the progress indicator example from JWalk?

http://j-walk.com/ss/excel/tips/tip34.htm


it uses a form and labels. change the code to suit your needs.



hope it helps

"mcdowell" wrote in message
...
I have a need to utilize a progress indicator which is time based.
Converting ascii "text" files to spreadsheets takes appx 5 min per
file. The conversion process can be for 1 or more files (up to 5). At
start time the number of files is determined. If processing 1 file
only the run time = 5 min, if 2 files run time = 10 min, etc. I would
like to display a progress indicator utilizing the system clock to
reflect the time left.

I have a UserForm "fmProgress" which has 2 "stacked" labels wiith
different colors.... That's as far as I can go! I need help with
writing code to make the top should grow (left to right) to cover the
bottom as a way to reflect the progress. I am also in the dark when
it comes to working with the system clock and using it to increment the
growth of the top label. If you have example code constructed (or
could construct same) I would greatly appreciate it!

I know that some of you have "been there, done that", hence I ask for
your assistance. Thank you very much.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/