Notification
What about doing it the standard way and use the Status Bar?
StatusBarStatus = Application.DisplayStatusBar
Application.DisplayStatusBar = True
Application.StatusBar = "Processing... please wait"
'
' Your code goes here
'
Application.StatusBar = False
Application.DisplayStatusBar = StatusBarStatus
--
Rick (MVP - Excel)
"David Gerstman" wrote in message
...
I have a userform to input some data. After the user presses the "enter"
button, the data is recorded.
I've been asked to have an indicator that flashes for a moment to indicate
that information is being saved.
I was thinking of having text in a label that would say "SAVING..." in red
letters for a second or two. How would I accomplish that?
Thank you,
David
|