Blinking text

A

Aimee

Hello,
Does anyone know how to make the text blink in Excel sheets?
Thanks for your help!
Aimee
 
F

Frank Kabel

Hi
though this is possible (search Google for 'blinking cell') I' strongly
suggest not to do this:
- all solutions involve the usage of the OnTime method in VBA and will
slow down Excel
- blinking cells have nothing to do with serious spreadsheets :)
 
S

Stephen Rasey

Use Conditional Formating instead.
You can make the text Bold, Italic, and change its color.
You can make the cell interior (background) a color based upon a
condition.
This highlights cells even on a printout.

Stephen Rasey
WiserWays, LLC
Houston, TX
 
N

Norman Harker

Hi Aimee!

I agree with Frank!

At least this approach only flashes if there's a change to the
offending cell.

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Me.Range("MyFlashCell")) Is Nothing Then Exit Sub
Dim n As Integer
Dim NextTime As Date
If Range("MyFlashCell").Value > 7 Then
For n = 1 To 5
With Range("MyFlashCell").Font
If .ColorIndex = 2 Then .ColorIndex = 3 Else .ColorIndex = 2
End With
With Range("MyFlashCell").Interior
If .ColorIndex = 3 Then .ColorIndex = 2 Else .ColorIndex = 3
End With
Application.Wait Now + TimeValue("00:00:01")
Next
End If
With Range("MyFlashCell")
..Font.ColorIndex = 3
..Interior.ColorIndex = 2
End With
End Sub

But don't do it unless you are really into annoying people who use the
workbook.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top