how to add a progress bar in existing macro?

[athlug]

good morning everybody!
could someone give me some info,how to add a progress bar in my macro-enabled workbook?
the macro is tested,runs fine,i know only how to add a userform....could you assist?
thanks!

[dgwebster]

I find progress bars to be really flaky.

my personal favourite is to use

Please Login or Register  to view this content.

in the quotes, enter what stage your macro is at.


at the end, insert

Please Login or Register  to view this content.

Sent from my HTC One_M8 using Tapatalk

[athlug]

oh well...thanks for the quick reply...could you give me some more info,some sample of code maybe?

[dgwebster]

on a progress bar or on using the statusbar? if the latter, the code is exactly has above, pop it I to your code and when it runs the statusbar at the bottom left displays what you want it to.

some examples I have done are:

application.statusbar = "Initiating global variables"

another, within a loop that processes a number of CSV files:

Please Login or Register  to view this content.

Sent from my HTC One_M8 using Tapatalk

[athlug]

folks,i upload a file that i made,got the bar,but needs some sync between the actions and the bar....
the bar runs,but with no sync....
could someone advice?