How can i add a VBA progress bar with percent based on Subs completed

[LNG2013]

Hey everyone!

I have a fairly extensive macro, and it takes up to a couple minutes to complete. The macro essentially pulls in a csv and cleans it up. There are a total of 17 Subs - and I was wondering while the Subs are working through if there was a way to display a Progress bar, that indicated percent complete by each sub complete?

 

[Trevor G]

Take a look at this link to see if it helps.

http://excel.tips.net/T002496_Using_a_Progress_Indicator_in_Macros.html

or

http://spreadsheetpage.com/index.php/site/tip/displaying_a_progress_indicator/