how can i get a cell to flash or blink

[Lee K]

i want to make the balance on my worksheet stand out by flashing, is that
possible in excel?

[Gary''s Student]

You might try an OnTime Event procedure to alternately change a cell's
background color back and forth. But it would not blink very fast.

--
Gary's Student


"Lee K" wrote:

> i want to make the balance on my worksheet stand out by flashing, is that
> possible in excel?
>

[Desert Piranha]

i want to make the balance on my worksheet stand out by flashing, is that
possible in excel?

Hi Lee,
See if this will help.

http://www.cpearson.com/excel/BlinkingText.htm

http://exceltips.vitalnews.com/Pages...ing_Cells.html

Or something like this, Change for text, color, range, or blinking rate, to suit:

Public blStop As Boolean
'------------------------------
Public Sub Blink()
'Code from Norman Jones
Dim rngCell As Range
Dim rngRegion As Range
Dim appTime As Double
If blStop Then Exit Sub
Set rngRegion = Sheets(1).Range("A1:B10")
For Each rngCell In rngRegion
With rngCell
.Interior.ColorIndex = IIf(.Interior.ColorIndex = 2, 3, 2)
End With
Next rngCell
appTime = Now() + TimeValue("00:00:01")
Application.OnTime appTime, "Blink"
End Sub
'------------------------------
Public Sub StartIt()
blStop = False
Blink
End Sub
'------------------------------
Public Sub StopIt()
blStop = True
End Sub