View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Help with code for timing

'you could have the status bar show a message
'put this at the beging of your code
Application.DisplayStatusBar = True
Application.StatusBar = "My macro is running..."
Application.Wait Now + TimeValue("00:00:05")
'and then at the end of your code you need to have this
Application.StatusBar = False

"Noemi" wrote:

Hi

While I have my code running from a Form is is possible to have another form
come up with a message that its processing as at the moment you cannot tell
if it is running or not.

I will also need to have the message change once the process has stopped.

FYI, the code is run after txt feilds have been updated and then a commnad
button is pressed.

Thanks
Noemi