Is it possible to create a progress indicator in VBA without a loop?

[jdmc45]

Hi,

So is it possible to create a progress indicator in VBA without a loop?
Such as when a macro is doing basic formatting like resizing columns, for example. And if so, does anyone have any code for it or an idea about how to go about the code?

Cheers!

James

 

[jdmc45]

I assume from the lack of reply that it is impossible to do

 

[Sektor]

What do you mean "progress indicator without a loop"?
Then what for progress indicator without a loop?

 

[RoryA]

You don't have to have a loop to use a progress indicator but you do then need to have another method of determining the progress percentage at each point. None of the progress bars I've seen or used care about what sort of routine they are called from - they just need to be told how much progress to display.

 

[Ruddles]

Or to put it another way: you start a progress indicator with a value of zero, or 0%, and then update it as processing continues to indicate to the user how much processing has been completed.

If you don't update the progress indicator from the process as it continues, where are you planning to update it from? The process need not be a loop of any kind - it could merely be several blocks of code and you update the progress indicator after each one has completed - but the progress indicator has to be told what value to display and when.

You can't just say to the progress indicator, "This next bit of code takes ages so change yourself at the appropriate intervals to reflect how much longer you think is left to go" - you have to work it out yourself and code the change yourself.

I'm not sure that is actually putting it another way, but hopefully you get the idea.

 

[Ruddles]

 

[RoryA]

Funnily enough I saw that one again last week

 

[PritishS]

Hi,

So is it possible to create a progress indicator in VBA without a loop?
Such as when a macro is doing basic formatting like resizing columns, for example. And if so, does anyone have any code for it or an idea about how to go about the code?

Cheers!

James

It is possible.
Check my answer
Progress bar with no loop ?

Hope this help someone in need.

Thank you
PritishS