Setting a 10 second timer in excel

[njwcad]

Hello can anyone help

Is it possible to set a 10 second timer in excel that delays conditional formatting of one cell by 10 seconds following a result from another cell using VB code


Any help would be greatly appreciated

Many Thanks

 

[SkipVought]

Hi,

Check out the Timer function

    Dim t As Date, dur As Integer
    t = Timer
    dur = 10
    Do While t + dur > Timer
       DoEvents
    Loop
    'now format the range

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[vladk]

Or API Sleep function