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:

'First Message
Application.StatusBar = String(5, ChrW(9609)) & "Blah Blah Blah..."
Application.Wait Now + TimeValue("00:00:02") '-- Replace this line with your own code to do something
'2nd Message
Application.StatusBar = String(10, ChrW(9609)) & "Blah Blah Bam Boo..."
Application.Wait Now + TimeValue("00:00:02") '-- Replace this line with your own code to do something
'3rd Message
Application.StatusBar = String(15, ChrW(9609)) & "Bam Bam Bam Boom..."
Application.Wait Now + TimeValue("00:00:02") '-- Replace this line with your own code to do something
'4th Message
Application.StatusBar = String(20, ChrW(9609)) & "Fap Fap Fap Fap Ahh..."
Application.Wait Now + TimeValue("00:00:02") '-- Replace this line with your own code to do something
' Message
Application.StatusBar = String(25, ChrW(9609)) & "Raaaaaaarghh..."
Application.Wait Now + TimeValue("00:00:02") '-- Replace this line with your own code to do something

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