View original (French)

Pause in an Excel macro

kittie -  
 kittie -
Hello everyone!!

Can someone tell me what the instruction or command is to insert a pause in a macro in Excel 2000 to allow for the entry of new elements in a file, and then once the input is complete, for the macro to resume execution?

Thanks in advance
kittie

1 réponse

Réponse 1 / 1
bmgg4 Posted messages 189 Registration date   Status Membre 23
 
Hello Kittie,

You have several options 
You need to use the OnTime method. 
Example: 
Sub ALuumer() 
MsgBox "You need to wait" 
Application.OnTime Now + 
TimeValue("00:00:15"), "Eteindre" 
End Sub 
Sub Eteindre() 
MsgBox "15 seconds have elapsed" 
End Sub 
Best regards 
 
Pascal (Papou) 
 
This function 
is also interesting 
 
Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) 
Sub Tempo() 
 MsgBox "Msg 1" 
 Sleep (1000) ' pause of 1 second 
 MsgBox "Msg 2" 
 Sleep (3000) ' pause of 3 seconds 
 MsgBox "Msg 3" 
End Sub 
 
Bruno BdF

macros published on http://www.excelabo.net/xl/tempo.htm
Other options on http://perso.wanadoo.fr/frederic.sigonneau/Tempos.htm

Monique
Isn't life beautiful?
1
kittie
 
Hello

I hope you are doing well
thank you very much for your response
kisses kittie
0