VBA Progress Meter

Hi, I wonder whether someone may be able to help me please.

I'm trying to implement the 'Progress Bar' shown here: http://datapigtechnologies.com/blog/...he-status-bar/ but I'm having a little difficulty in doing so.

This is my code which I've implemented this:

Please Login or Register  to view this content.

The problem I have is that the blue progress bar is shown and hence doesn't move across the Status Bar. In addition, the only message which is shown is "Still Working".

I just wondered whether someone may be able to look at this please and offer some guidance on how I can solve this.

Many thanks and kind regards

Chris

You aren't incrementing the first parameter in the String function, all you use is:

Please Login or Register  to view this content.

This should be:

Please Login or Register  to view this content.

I suspect this won't really have the effect you want since it really needs a loop, but got for it

Hi @Kyle123, thank you for taking the time to come back to me with this, but unfortunately all the increase number does is in crease the length of the 'Status Bar' message width rather than implement the individual progress segments.

Many thanks and kind regards

Chris

It increases the size of the progress bar, due to the change in 2013 vs earlier Excel versions the segments won't separate. You could do something like:

Please Login or Register  to view this content.

Though if that would work for you?

Hi @Kyle123, thank you very much for this. I think I'll have to see if I can find another example to work with Excel 2013 because all the code you suggested works, I would have to repeat multiple times for each part of my script which may become a little cumbersome.

Many thanks and kind regards

Chris

Can't you just make a little function?

Please Login or Register  to view this content.

Then:

Please Login or Register  to view this content.

Hi, that's a good idea, I'll give this a try.

Kind Regards

Chris