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. ![Eek! :eeek: :eeek:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f631.png)
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~
![Cool :cool: :cool:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f60e.png)
![Eek! :eeek: :eeek:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f631.png)
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.
![Wink ;) ;)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f609.png)
At the very least, maybe my next dream will be about laying on a warm beach somewhere...
Thanks,
~ZM~
![Cool :cool: :cool:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f60e.png)