Flashing cell content in Excel

[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.

 

[J.E. McGimpsey]

Yes, unfortunately. And no.

You'll need an .OnTime macro to accomplish this. Check the archives
for "cell blink" or "cell flash".

http://google.com/advanced_group_search?q=group:*excel*

 

[ste mac]

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