Display text for one second

Trickle

New Member
Joined
Feb 23, 2012
Messages
9
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
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,779
Perhaps
Code:
Sub test()
    With Range("A1")
        .Value = "Reset"
        Application.Wait Now() + TimeSerial(0, 0, 1)
        .Value = vbNullString
    End With
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,108,491
Messages
5,523,255
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top