Blinking text

  • Thread starter Thread starter Aimee
  • Start date Start date
A

Aimee

Hello,
Does anyone know how to make the text blink in Excel sheets?
Thanks for your help!
Aimee
 
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 :-)
 
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
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top