Flashing cell content in Excel

  • Thread starter Thread starter D.M.Beiso
  • Start date Start date
D

D.M.Beiso

Hi
Is it possible to make the contents of a cell flash intermittently?
Is it possible to accomplish this using the cell formula itself?
anticipated thanks
Dennis.
 
This will make it flash..

Sub Flash()
NextTime = Now + TimeValue("00:00:01")
With Cells(1, 1).Font
If .ColorIndex = 2 Then .ColorIndex = 3 Else .ColorIndex = 2
End With
Application.OnTime NextTime, "Flash"
End Sub

Sub StopIt()
Application.OnTime NextTime, "Flash"
Application.OnTime NextTime, "Flash", schedule:=False
Cells(1, 1).Font.ColorIndex = xlAutomatic
End Sub

seeya ste
 
Back
Top