VBA Status Bar Message

[hobbiton73]

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

I've found a 'Status Bar' message here: http://www.vbaexpress.com/kb/getarticle.php?kb_id=993 which I'd like to implement into a Excel workbook I extract files within.

Following the instructions I replaced

Please Login or Register  to view this content.

with my own code, so the full script looks like:

Please Login or Register  to view this content.

But the problem I've got is that the 'Countdown' and '% Completion' don't work and the macro constantly runs on a loop, so I've clearly done something wrong.

I've spent sometime researching Do Loops but I just can't get my ahead around this, so I just wondered whether someone may be able to look at this please and let me know where I've gone wrong.

Many thanks and kind regards

Chris

[LokeshKumar]

Hey,
I have just seen, I have not found any sub you are calling like this.
Maybe it is not the complete code.....

Please Login or Register  to view this content.

[hobbiton73]

Hi @LokeshKumar, thank you for taking the time to come back to me with this. As per the note in the code which I posted, this is my script which I'm trying to incorporate. My apologies for not making this clear.

Kind Regards

Chris

[LokeshKumar]

If you upload the workbook with the code.....and what kind of error you are getting.....that would be so helpful for me...

[hobbiton73]

Hi when I upload the original file from the website link, the code works perfectly without any error.

When I then intergrate my code into this the 'Status Bar' message is "Processing 17%" the whole script runs, then the script starts again with the 'Status Bar' message showing "Processing 33%", and it continues like this increaing the "Processing" % by 17% each time, so it's clearly something wrong with the loop. But I don't receive any error message.

Many thanks and kind regards

Chris

[Kyle123]

You're trying to run your code 600 times, that's why it goes on forever.

In summary, you can't really use a progress meter without a loop since you have nothing to increment it with, your best bet for something like this would be :

Please Login or Register  to view this content.

And skip all the loop stuff

[hobbiton73]

Hi @Kyle123, thank you for taking the time to reply to my post. Yes I'd realised through the testing I'd one that the loop was needed, but it was a question of trying to implement this with my existing script, because I was keen in reproducing the format of the example I'd found.

Many thanks and regards

Chris

[Kyle123]

Unfortunately you can't since your code doesn't have a loop, unless it's in the subs you call - in which case you could put it there.

TBH I'd look at making your code faster, there doesn't seem to be anything there that warrants a progress bar

[hobbiton73]

Ok, thank you for your help.

Kind regards

Chris