CHALLENG:Middle of Excel screen indicating macro/VBA running

[Dukesford]

I know this code below will appear at the bottom left corner of excel in the Status Bar indicating the status of the macro running.

Sub Pivot_Table_Refresh()
Application.StatusBar = "Working..."
.
.
Rest of code
.
.
Application.StatusBar = "Ready"
End Sub

I am curious, just would be a kinda cool thing to show like a watermark or something that appears in LARGE font in the middle of the screen showing the macro running. It will serve both a cosmetic and functional purpose. Functionally it will let people not familiar with macros to know when they are done, I know the status bar works, but could it be possible? A tough Challenge.

 

[Smitty]

There are several methods for How to display a progress bar with a user form in Excel.

Searching the MSKB should turn up a few alternatives as well, that's just one.

You can also redraw text on a blank sheet while the code runs, similar to using the StatusBar.

HTH,

Smitty