macro to continue after 5 min or I hit Enter key
plse add code
[VBA]' Waits 5 min
Application.Wait Time + TimeSerial(0, 5, 0)
' Continues here after pause[/VBA]
macro to continue after 5 min or I hit Enter key
plse add code
[VBA]' Waits 5 min
Application.Wait Time + TimeSerial(0, 5, 0)
' Continues here after pause[/VBA]
[VBA]Option Explicit
Sub macroWait()
MsgBox "Wait"
Application.Wait Now + TimeValue("00:00:05")
MsgBox "Go"
End Sub[/VBA]
Thank you for your code.
my vba is:
a
b
c
d
if I want to wait after b and continue after c, what code to add between b and c,plse?
a
b
Call MacroWait
c
d
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thank you for your help.
In your question I am not getting you want position of call or saying a,b,c character checking so I am replying both.
first: when we have to call any code according to our desire we could type our code in procedure and call it wherever we want to call.
second: you could check ASCII value of a b c characters and call your procedure.
I hope you would get your answer.