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
|