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 answer

  1.
    bmgg4 Posted messages 189 Registration date   Status Member 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
    1. kittie
       
      Hello

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