Blinking Text?

  • Thread starter Thread starter GK
  • Start date Start date
G

GK

I'm trying to find a way (without using VBA) of formatting a cell in such a way that it flashes or does other groovy things.

In Word XP there are special text effects which include blinking. fading in/out etc.........


I'm running Excel XP
Does anyone know of an add-in or other simple way of doing this OR getting other extra formats
 
Sorry, can't be done!
-----Original Message-----
I'm trying to find a way (without using VBA) of
Click to expand...
formatting a cell in such a way that it flashes or does
other groovy things.
In Word XP there are special text effects which include
Click to expand...
blinking. fading in/out etc.........
I'm running Excel XP
Does anyone know of an add-in or other simple way of
Click to expand...
doing this OR getting other extra formats
 
There is a way if you really want
here is an example that Bill Manville posted


The following code will blink any cells that have the style Blink
(create a new style using Format / Style). Format the cell concerned
with style Blink and then run macro Flash to initiate the process.
Since the cell is blank if not showing ERROR you will not see the
blinking unless ERROR is displayed.

Dim NextTime As Date

Sub Flash()
NextTime = Now + TimeValue("00:00:01")
With ActiveWorkbook.Styles("Blink").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.Styles("Blink").Font.ColorIndex = xlAutomatic
End Sub
 
Except that he said he doesn't want to use VBA. Without VBA, this isn't possible, right?
 
Back
Top