help makra w Exscel

Thread View: pl.comp.lang.vbasic

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Timex Wed, 26 Nov 1997 13:18

#211

Author: Timex
Date: Wed, 26 Nov 1997 13:18

7 lines
749 bytes

 Moze ktos wie jak mozna napisac (dopisac)polecenie w arkuszu Makra

polecenie: Zatrzymaj wykonywanie nastepnego polecenia na 10 sek

Dziekuje z góry za odpowiedz

zt

Re: help makra w Exscel

#212

Author: Kazimierz Osiński
Date: Wed, 26 Nov 1997 14:30

14 lines
1166 bytes

Metoda expression.Wait(Time) zatrzymuje makro na okreslony czas.
    Przykłady zastosowania z help'a VB w excellu:
    
    This example pauses a running macro until 6:23 P.M. today.
    Application.Wait "18:23:00"
    This example pauses a running macro for approximately 10 seconds.
    newHour = Hour(Now())
    newMinute = Minute(Now())
    newSecond = Second(Now()) + 10
    waitTime = TimeSerial(newHour, newMinute, newSecond)
    Application.Wait waitTime 
    
    Kazimierz Osiński
    kaziko@cso.com.pl

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads