Help with code for timing
 

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

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

Help with code for timing
 

Hi Mike
For some reason the status bar doesn't come up.

Could this be because I have a form open and if so is there a way around it.

Thanks
Noemi

"Mike" wrote:

'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

Help with code for timing
 

The status bar is at the bottom left corner of excel

"Noemi" wrote:

Hi Mike
For some reason the status bar doesn't come up.

Could this be because I have a form open and if so is there a way around it.

Thanks
Noemi

"Mike" wrote:

'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