Just for fun ... (I had a dream)

[zombiemaster]

Yes, I had a dream about Excel. I don't quite know what to think about that but I'm going to just go with it.

So I woke up 45 minutes late for work today (yup, off to a wonderful start) and remembered part of a dream I had about VBA and it won't leave my tired brain.

Is it possible to have a Message Box appear on the screen that STAYS on the screen while a macro is running, which updates the message as the code runs? I know about this:

Application.StatusBar = "This Puts Words In The Status Bar"

That can be repeated throughout the code to update users on the progress, but can this be done with a stationary Message Box and each time the code hits a trigger, the message changes?

Thanks for looking; I figure if anyone will be able to answer this sleep-deprived question, it would be this group. And it might provide a bit of fun diversion from the usual panic-stricken questions that can sometimes plague these forums.

At the very least, maybe my next dream will be about laying on a warm beach somewhere...

Thanks,
~ZM~

 

[Fluff]

Not asure about a message box, but you could do that with a userform

 

[footoo]

Could also do with a textbox.

 

[Jaafar Tribak]

Can be done with API code either using a Windows Timer or a using Windows hook