Display multiple messages in status bar while macro is running

Hi Team,

I was wondering if there was a way in vba, to have the status bar, display multiple messages (one at a time of course), whislt a macro is running in the background? (Yes, this is for entertainment purposes for the user whilst they wait for the macro to finish).

I found this --> http://datapigtechnologies.com/blog/...he-status-bar/ - here part of the code displays a series of messages at certain timed intervals if I understand it correctly (correct me if I am wrong please). So i was thinking, going from the example in the provided link, would it be a matter of duplicating the "status bar message" code?

What I am thinking is this:

Please Login or Register  to view this content.

And so on...

I understand the original example in the link above is to represent a progress meter of some kind, but what I am looking to do is to code in a bunch of useless facts for the user to read whilst waiting.

Would this be the way to do as per above? or could there be a more efficient way in accomplishing this task?

Many Thanks for any help given :-)

Hooroo

Good afternoon StevTheFish

...and welcome to the forum!!

You're on the way there, but...

What the code does is wait a fixed period before changing the message. The wait will halt all executing message, so you're macro won't run until all the lessages have been displayed.

I assume you're using some kind of loop to run the macro? It all depends what's going on, but the easiest way is to build a counter in your loop, start at zero, and increment with one every loop. Then include a check that if, say, C=5,000, then show message 1. If C=10,000 then show message 2 etc.

HTH

DominicB

Hi DominicB - Thanks so much for helping out

I was about to run off to the hills and dance my way to victory until you said loop and a check part. I looked further into the example in the link above and found that another excel sensai commented explaining something very similar as what you have suggested with the following:

by Andy Pope ([email protected])

Please Login or Register  to view this content.

So, with all honesty, I have tried just copying this sucker in to work with my macro, but won't work and yes, this is where my brain stops me and says chill out

Any way to make this work, with the idea you have suggested?

Alternatively, I am just thinking to leave the thing as it is and the user can just wait with no messages.

Hi SteveTheFish

Can you post your code, or even a workbook containing your code.
Someone will need to see what it's doing and when.

If your code is really long (ie, lots of it) you might just be able to put the different messages in at strategic points.

HTH

DominicB

Originally Posted by dominicb

Hi SteveTheFish

Can you post your code, or even a workbook containing your code.
Someone will need to see what it's doing and when.

If your code is really long (ie, lots of it) you might just be able to put the different messages in at strategic points.

HTH

DominicB

Hey DominicB - Thanks for your the additional help

I was able to track down another excel guru in another department to give me a hand with this. I shared with him your suggestions and he agreed with your idea of placing messages at certain points would be the easiest way due to the way I have built my code to run (i.e - Very Nooby & messy, but still works - and yes it is quite long). I've also shared the link to this post so hopefully he'll drop in to say 'Thanks' himself otherwise a big THANK YOU from both of us haha

Cheers - Steve