zombiemaster
Board Regular
- Joined
- Oct 27, 2009
- Messages
- 245
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:
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~


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:
Code:
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.

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