Excel macro application pause.

hunchgun · November 11th, 2005, 11:11 PM

Can anyone tell me how can i pause or stop the application in the middle of my program for a few seconds and continue running back after that.

Sleep xxxx dont work because it still running the application.

i had tried many inbuild functions, but still can't find out ...

Pls help. thanks.

quiksilverhg · November 12th, 2005, 01:20 AM

You want it to pause while you're debugging or just stop it where it's at while it's running?

If you're debugging you can 'run to cursor'

If you want to stop it in the middle at least on mine you can just hit escape then it will give you the options "help", "debug", "continue"

Is that what you wanted?

vemaju · November 12th, 2005, 02:36 AM

Hi,

Use this code for waiting 5 seconds

Sub Wait()
' Waits 5 seconds
Application.Wait Time + TimeSerial(0, 0, 5)
' Continues here after pause
End Sub

-vemaju

hunchgun · November 12th, 2005, 01:58 PM

I want to stop in the middle of running.

Vemaju,
Your subroutine almost help.
Let me explain more detail on it.

my sheet 1 is connected to FLUKE DAQ so the cell value is changing in real time. It will always trigger on that sheet.
What i want is running macro at the background, keep on polling the triggering cell and detect for change.
I am not familiar with macro, and i found out that once i run the macro, the sheet will stop triggering.

I am not sure macro can do kinda multithread thing, where the macro running at background and the cell value still triggering.

Hope you guys can help....
Thanks a lot.

hunchgun · November 12th, 2005, 02:46 PM

I think i can't do it. Do you guys have any other idea?

"The only thing you cannot do is work in the foreground on the same workbook which the macro is using."

http://exceltips.vitalnews.com/Pages...s_Running.html

Christo · November 21st, 2009, 04:36 AM

Quote:

Originally Posted by vemaju

Hi,

Use this code for waiting 5 seconds

Sub Wait()
' Waits 5 seconds
Application.Wait Time + TimeSerial(0, 0, 5)
' Continues here after pause
End Sub

-vemaju

Vemaju!! Thank you. I was looking for a similar solution too and this one is a simple yet perfect one.

Thanks again

checktechno · November 25th, 2012, 01:10 PM

tested on Excel 2010 and 2013, still works great! http://checktechno.blogspot.com/2012/11/vba-sleep.html

TimeValue also handle string time format. Using TimeValue("00:00:05") vs TimeValue(0,0,5)

Code:

Public Sub Test2()
    Application.Wait(Now + TimeValue("0:00:03"))
    MsgBox("hello")
End Sub

@hunchgun : I am not sure macro can do kinda multithread thing, where the macro running at background and the cell value still triggering.

is more complicate....