Progress Bar count lines of code 1

[smma]

Hello! I woud like to make a progress bar hack that uses the width of a textbox as the size of the bar. My question is how can I have the progress bar show while my macros are working in the background? Additionally, I would like the bar to increment for each line of code read, so the progress would be relevant to the code being processed. Has anyone found a good way to do this? I have found several examples online, but nothing that will encompass these criteria. Or, would a regular ProgressBar control in VBA be the best choice? Thank you for your input!

 

[handleman]

Umm, updating a control requires a line of code. You want to update the control each time a line of code is processed. Your program will do nothing but update the progress bar.

 

[smma]

So how do I update the control as each line is processed? That is what I am unsure of. I would like my Progress Bar (or TextBox) width to change for each line of code processed. What I don't know is how to read a line of code as a number and send it to the bar to change its width. Additionally, is there a way to run both the foreground Progress Bar and the background macro simultaneously? Thanks.

 

[IRstuff]

Huh? Each line of code, you increment a counter.

TTFN

FAQ731-376

 

[joerd]

Download the following files, these are different approaches to programming a progress bar:

http://www.erlandsendata.no/downloads/progressbarexamples.zip

http://www.erlandsendata.no/downloads/progressbarcontrol.zip

http://www.erlandsendata.no/downloads/pictureprogress.zip

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.