Display text for one second

[Trickle]

Hi

Could anyone tell me if it is possible to display "Reset" in a given cell for a duration of one second?

Many thanks in anticipation.

Trickle

 

[mikerickson]

Perhaps

Sub test()
    With Range("A1")
        .Value = "Reset"
        Application.Wait Now() + TimeSerial(0, 0, 1)
        .Value = vbNullString
    End With
End Sub

 

[Trickle]

Many thanks Mike for your quick response - I'll try this out.

Trickle