Thread: Notification
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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