Format Cell to Blink

  • Thread starter Thread starter Lenny
  • Start date Start date
L

Lenny

Can a cell be formatted to blink constantly (or just the
characters blink, or the colors change)?

Suppose you wanted to have instructions as part of a
worksheet and you wanted to start with:

WARNING!

but you wanted that cell to blink either on or off or
change colors or something to attract attention. Can this
be done and if so, how?

Any input would be appreciated.

Lenny
 
Blinking can't be done AFAIK (and thank goodness, any spreadsheet that I met
would be straight out of the window).

You could use conditional formatting to give it a fill colour.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi bob
not sure I should post this (as I totally agree with you that blinking
cells sould be forbidden) but to show it can be done try the following
:-)

Dim Nexttime
Sub Flash()
NextTime = Now + TimeValue("00:00:01")
With ActiveWorkbook.Worksheets("Tabelle3").Range("A1").Font
If .ColorIndex = 2 Then .ColorIndex = 3 Else .ColorIndex = 2
End With
Application.OnTime NextTime, "Flash"
End Sub

Sub StopIt()
Application.OnTime NextTime, "Flash", schedule:=False
ActiveWorkbook.Worksheets("Tabelle3").Range("A1").Font.ColorIndex =
xlAutomatic
End Sub

Frank
 
Bob
Beautiful, isn't it ;-)
you should try this with a custom style applied to many cells and using
different (random) colors. If you like I can email you an example <vbg>

Frank
 
Back
Top